Totaling data between dates
 

I am working on a spreadsheet that I would like to total each day.
I have Column A (Manually entering in a date), Column B is where a valued is
entered. An. Example would be
A1 03/01/07- B1 5, A2 03/01/07- B2 10 and A3
03/05/07 and B3 4
A date in Col A. could range from a row or several hundred rows ( tracking
packages shipped). Column B is the value of each package. I am looking for
a way to track everything on a per day basis. Any Suggestions??

Totaling data between dates
 

=sumproduct((a2:a222=a1)*(a2:a222<b1)*b2:b222)

--
Don Guillett
SalesAid Software

"Val" wrote in message
...
I am working on a spreadsheet that I would like to total each day.
I have Column A (Manually entering in a date), Column B is where a valued
is
entered. An. Example would be
A1 03/01/07- B1 5, A2 03/01/07- B2 10 and A3
03/05/07 and B3 4
A date in Col A. could range from a row or several hundred rows (
tracking
packages shipped). Column B is the value of each package. I am looking
for
a way to track everything on a per day basis. Any Suggestions??

Totaling data between dates
 

Sum of values for 01/03/07 (UK date!)

=SUMIF($A$2:$A$7,DATEVALUE("01/03/07"),$B$2:$B$7)

Count of sipments for 01/03/07 (UK date!)

=COUNTIF($A$2:$A$7,DATEVALUE("01/03/07"))

You can replace the DATEVALUE with a cell contain the date

=SUMIF($A$2:$A$7,C2,$B$2:$B$7)

C2=01/03/07

HTH


"Val" wrote:

I am working on a spreadsheet that I would like to total each day.
I have Column A (Manually entering in a date), Column B is where a valued is
entered. An. Example would be
A1 03/01/07- B1 5, A2 03/01/07- B2 10 and A3
03/05/07 and B3 4
A date in Col A. could range from a row or several hundred rows ( tracking
packages shipped). Column B is the value of each package. I am looking for
a way to track everything on a per day basis. Any Suggestions??

Totaling data between dates
 

or even: =SUMIF(A2:A??,TODAY(),B2:B??)
will always just show todays total.
If you want to see the total for every day, use data, subtotal command and
tell it for each change in column A (date), use function sum, and add
subtotal to column b.
This will give you a subtotal for each date as well as a grand total for all
dates.
There will be an outline bar to the left which will allow you to expand or
colapse to see detail as needed.
When you have printed what you need, go back to data, subtotal and click
remove subtotals so you can add more records the next day. Do not add or
remove while subtotals are turned on.
Have fun!

"Val" wrote:

I am working on a spreadsheet that I would like to total each day.
I have Column A (Manually entering in a date), Column B is where a valued is
entered. An. Example would be
A1 03/01/07- B1 5, A2 03/01/07- B2 10 and A3
03/05/07 and B3 4
A date in Col A. could range from a row or several hundred rows ( tracking
packages shipped). Column B is the value of each package. I am looking for
a way to track everything on a per day basis. Any Suggestions??