How do I create a spreadsheet?

B

badgirl1016

I need create a simple spreadsheet. To show the total number of tasks that
was comlpeted that week. Can you help me?
 
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?
Click to expand...

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Need Help with Macro Security 1
Integrating information from Word to Excel (not mail merge) 1
Re-title multiple MS Project .mpp files at once 0
Dealing with a Pivot Table (when I don't want to) 0
Incone & Expenses Statement 0
How to implement two shifts per day with multiple teams 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top