Thread: Totals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve[_18_] Steve[_18_] is offline
external usenet poster
 
Posts: 9
Default Totals

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