G
Guest
I need create a simple spreadsheet. To show the total number of tasks that
was comlpeted that week. Can you help me?
was comlpeted that week. Can you help me?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
oldchippy
badgirl1016 said:I need create a simple spreadsheet. To show the total number of task
that
was comlpeted that week. Can you help me?
Hi badgirl1016,
It depends how simple it was and how many tasks you did, but here's
very simple one,
Col A Col b
Monday 1
Tuesday 1
Wednesday 1
Thursday 1
Friday 1
in cell b6 =SUM(B1:B5)
oldchippy :
P
Pete_UK
Your request is a bit vague, but how about this:
Enter the days of the week in cells A1, A2 etc down to A7. In column B
you can enter the number of tasks completed for each day. In C1 enter
the word "Total", and in D1 enter this formula:
=SUM(B1:B7)
Is this the kind of thing you were after?
Hope this helps.
Pete
Enter the days of the week in cells A1, A2 etc down to A7. In column B
you can enter the number of tasks completed for each day. In C1 enter
the word "Total", and in D1 enter this formula:
=SUM(B1:B7)
Is this the kind of thing you were after?
Hope this helps.
Pete
P
Pete_UK
Hey oldchippy,
What are the chances of the two of us posting at exactly the same time
an almost identical solution to such a vague request ??
Pete
What are the chances of the two of us posting at exactly the same time
an almost identical solution to such a vague request ??
Pete
O
oldchippy
Pete_UK said:Hey oldchippy,
What are the chances of the two of us posting at exactly the same time
an almost identical solution to such a vague request ??
Pete
http://www.excelforum.com/showthread.php?threadid=570543
Great minds think alike, or are we all like this in the UK