ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I create a spreadsheet? (https://www.excelbanter.com/new-users-excel/104389-how-do-i-create-spreadsheet.html)

badgirl1016

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?

oldchippy

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


Pete_UK

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?



Pete_UK

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



oldchippy

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



All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com