Hi,

Try this

=sumproduct((F8:F10000<=today()+30)*(F8:F10000tod ay())*(A8:A10000="Approved")*(G8:G10000))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"JeffK" wrote in message
...
I have a formula:

=SUMIF(F8:F10000,"<="&TODAY()+30,G8:G10000)-SUMIF(F8:F10000,"<"&TODAY(),G8:G10000)

That I'd like to put a condition on that it will only sum if A8:A10000 =
"Approved"