SUMIFS and dates

[JLR-Mart]

I have some data and wish to use the sumifs function to add up sums when a
criteria is true and the date is less than a month ago. I have tried using
date-30 to no avail. Any suggestions?

 

[Roger Govier]

Hi

Something like the following, with dates in A, Criteria in B and Values in
C.
I put 01 Jan 2009 in I1 and 01 Feb in J1

=SUMIFS(C2:C5,B2:B5,"A",A2:A5,">="&I1,A2:A5,"<"&J1)

 

[JLR-Mart]

I've used:

=SUMIFS(Current!F3:F1048576,Current!D31048576,"Petrol",Current!A3:A1048576,">="&Current!H2)

Where the content of Current!H2 = today()-30 (which equals 16/03/09)

BUT that doesn't result in a valid result.

Any ideas?

 

[Fred Smith]

There's nothing wrong with your syntax, so it must be your data.

"doesn't result in a valid result" doesn't give us much to go on. What
result did you get, and what did you expect?

Regards,
Fred.