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?