| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I create a spreadsheet?
I need create a simple spreadsheet. To show the total number of tasks that
was comlpeted that week. Can you help me? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a spreadsheet?
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 badgirl1016 wrote: I need create a simple spreadsheet. To show the total number of tasks that was comlpeted that week. Can you help me? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a spreadsheet?
badgirl1016 Wrote: I need create a simple spreadsheet. To show the total number of tasks 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 a very simple one, Col A Col b Monday 1 Tuesday 1 Wednesday 1 Thursday 1 Friday 1 in cell b6 =SUM(B1:B5) oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=570543 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a spreadsheet?
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 oldchippy wrote: badgirl1016 Wrote: I need create a simple spreadsheet. To show the total number of tasks 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 a very simple one, Col A Col b Monday 1 Tuesday 1 Wednesday 1 Thursday 1 Friday 1 in cell b6 =SUM(B1:B5) oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=570543 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I create a spreadsheet?
Pete_UK Wrote: 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 oldchippy wrote: badgirl1016 Wrote: I need create a simple spreadsheet. To show the total number of tasks 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 a very simple one, Col A Col b Monday 1 Tuesday 1 Wednesday 1 Thursday 1 Friday 1 in cell b6 =SUM(B1:B5) oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=570543 Great minds think alike, or are we all like this in the UK? -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=570543 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trying to create a spreadsheet on my community. need help ? | Excel Discussion (Misc queries) | |||
| Generating Simple Reports From A Master Spreadsheet | Excel Worksheet Functions | |||
| How can I create a master spreadsheet from different workbooks | Excel Discussion (Misc queries) | |||
| can i create a shortcut to open a spreadsheet read only? | Excel Discussion (Misc queries) | |||
| how to create and use a new spreadsheet based on a template | Excel Discussion (Misc queries) | |||
Hybrid Mode
