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?

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 )

--
Regards
Roger Govier

"JLR-Mart" wrote in message
...
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?

I've used:

=SUMIFS(Current!F3:F1048576,Current!D3:D1048576,"P etrol",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?

"Roger Govier" wrote:

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 )

--
Regards
Roger Govier

"JLR-Mart" wrote in message
...
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?

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.

"JLR-Mart" wrote in message
...
I've used:

=SUMIFS(Current!F3:F1048576,Current!D3:D1048576,"P etrol",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?

"Roger Govier" wrote:

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 )

--
Regards
Roger Govier

"JLR-Mart" wrote in message
...
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?