Totals
So when we get past March 9th next month, the total will be 1.
You don't have any entries in your sample data for the month of March so how
do you arrive at that result?
So when we get past March 9th
Why March 9th?
If you want to sum based on the *current* month:
=SUMPRODUCT(--(MONTH(A1:A100)=MONTH(NOW())),B1:B100)
--
Biff
Microsoft Excel MVP
"Steve" wrote in message
...
I have a sheet of which I will be inputted data onto every so often.
The worksheet has only two columns, date and points. I want the sheet
to automatically workout the amount of points in a rolling month.
A B
01/01/09 3
02/01/09 2
19/01/09 7
09/02/09 3
18/02/09 1
TOTAL = 4
So when we get past March 9th next month, the total will be 1. As this
is the months total of points. Can someone please help?
Steve
|