calculations within a date range

[cdb]

Is it possible to sum the numbers in one column based on a date criteria in another column

e.g. I need to count the number of requests received within a week of todays date, so in this case it would be 1

25/05/2004 (=today()

No of requests Date request sen
12 24/05/200
1 12/05/200
24 23/04/200
5 20/05/200

I have tried a sumif, where I used the criteria =SUMIF(B:B,">=A1-7",A4:A7) - where column B is the date request sent, A1 is todays date (using the calculation in Excel) and A4:A7 is the range with the no of requests.

 

[Frank Kabel]

Hi
try
=SUMIF(B4:B7,">=" & A1-7,A4:A7)

-----Original Message-----
Is it possible to sum the numbers in one column based on

a date criteria in another column?

e.g. I need to count the number of requests received

within a week of todays date, so in this case it would be
17

25/05/2004 (=today())

No of requests Date request sent
12 24/05/2004
1 12/05/2004
24 23/04/2004
5 20/05/2004

I have tried a sumif, where I used the criteria =SUMIF

(B:B,">=A1-7",A4:A7) - where column B is the date request
sent, A1 is todays date (using the calculation in Excel)
and A4:A7 is the range with the no of requests.

 

[cdb]

That seems to work fine now. Many thanks again

----- Frank Kabel wrote: ----

H
tr
=SUMIF(B4:B7,">=" & A1-7,A4:A7

-----Original Message----
Is it possible to sum the numbers in one column based on

a date criteria in another columnwithin a week of todays date, so in this case it would be
1

12 24/05/200
1 12/05/200
24 23/04/200
5 20/05/200

(B:B,">=A1-7",A4:A7) - where column B is the date request
sent, A1 is todays date (using the calculation in Excel)
and A4:A7 is the range with the no of requests