Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumif using today's date
I am trying to use SUMIF. In column A I have dates and column B there are
dollar values. I am trying to sum all dollar values due from today out to the next 7 days. How do I add 2 criteria to the sumif formula? |
#2
|
|||
|
|||
sumif using today's date
2 ways
=SUMIF(A2:A30,"="&TODAY(),B2:B30)-SUMIF(A2:A30,""&TODAY()+7,B2:B30) format result as non date or =SUMPRODUCT(--(A2:A30=TODAY()),--(A2:A30<=TODAY()+7),B2:B30) -- Regards, Peo Sjoblom (No private emails please) "Eqa" wrote in message ... I am trying to use SUMIF. In column A I have dates and column B there are dollar values. I am trying to sum all dollar values due from today out to the next 7 days. How do I add 2 criteria to the sumif formula? |
#3
|
|||
|
|||
sumif using today's date
Hi!
Try one of these: =SUMIF(A1:A13,"="&TODAY(),B1:B13)-SUMIF(A1:A13,""&TODAY()+7,B1:B13) =SUMPRODUCT(--(A1:A13=TODAY()),--(A1:A13<=TODAY()+7),B1:B13) You could even use a helper cell: C1 =TODAY() Then: =SUMIF(A1:A13,"="&C1,B1:B13)-SUMIF(A1:A13,""&C1+7,B1:B13) =SUMPRODUCT(--(A1:A13=C1),--(A1:A13<=C1+7),B1:B13) Biff "Eqa" wrote in message ... I am trying to use SUMIF. In column A I have dates and column B there are dollar values. I am trying to sum all dollar values due from today out to the next 7 days. How do I add 2 criteria to the sumif formula? |
#4
|
|||
|
|||
sumif using today's date
Thanks That is great and NOW seems so easy.
"Peo Sjoblom" wrote: 2 ways =SUMIF(A2:A30,"="&TODAY(),B2:B30)-SUMIF(A2:A30,""&TODAY()+7,B2:B30) format result as non date or =SUMPRODUCT(--(A2:A30=TODAY()),--(A2:A30<=TODAY()+7),B2:B30) -- Regards, Peo Sjoblom (No private emails please) "Eqa" wrote in message ... I am trying to use SUMIF. In column A I have dates and column B there are dollar values. I am trying to sum all dollar values due from today out to the next 7 days. How do I add 2 criteria to the sumif formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum a range if the date is is greater than today's date? | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
calculate no. of years between a date and today's date | Excel Worksheet Functions |