Sumif

  • Thread starter Thread starter JeffK
  • Start date Start date
J

JeffK

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"
 
Use SUMPRODUCT()..

=SUMPRODUCT((A8:A10000="Approved")*(F8:F10000>=TODAY())*
(F8:F10000<=TODAY()+30),G8:G10000)

If you are using 2007 check out help on SUMIFS()

If this post helps click Yes
 
Use this formula...

=SUM((A8:A10000="APPROVED")*(F8:F10000<=TODAY()+30)*G8:G10000)

This is an array formula so after pasting the formula place the cursor in
that cell and give F2 then press Cntrl+Shift+Enter.

After pressing Cntrl+Shift+Enter your formula will look like this..

{=SUM((A8:A10000="APPROVED")*(F8:F10000<=TODAY()+30)*G8:G10000)}

Then just drag it to the remaining cells or copy and paste the formula for
the remaining cells.

If this post helps, Click Yes!
 
Use this formula...

=SUM((A8:A10000="APPROVED")*(F8:F10000<=TODAY()+30)*G8:G10000)

This is an array formula so after pasting the formula place the cursor in
that cell and give F2 then press Cntrl+Shift+Enter.

After pressing Cntrl+Shift+Enter your formula will look like this..

{=SUM((A8:A10000="APPROVED")*(F8:F10000<=TODAY()+30)*G8:G10000)}

Then just drag it to the remaining cells or copy and paste the formula for
the remaining cells.

If this post helps, Click Yes!
 
Back
Top