|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 16th, 2009, 10:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIFS and dates
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? 
|
|
#2
April 16th, 2009, 10:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIFS and dates
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?
|
|
#3
April 16th, 2009, 10:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIFS and dates
I've used:
=SUMIFS(Current!F3:F1048576,Current!D3  1048576,"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?
|
|
#4
April 17th, 2009, 01:59 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIFS and dates
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 1048576,"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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
