Sumif
 

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"

Sumif
 

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"

Sumif
 

Use SUMPRODUCT()..

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

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

If this post helps click Yes
---------------
Jacob Skaria


"JeffK" wrote:

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"

Sumif
 

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()+3 0)*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!

--------------------
(Ms-Exl-Learner)
--------------------



"JeffK" wrote:

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"

Sumif
 

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()+3 0)*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!

--------------------
(Ms-Exl-Learner)
--------------------



"JeffK" wrote:

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"

Sumif
 

I think you probably intended to say
=SUM((A8:A10000="APPROVED")*(F8:F10000<=TODAY()+30 )*(F8:F10000TODAY())*G8:G10000)?Personally I would use SUMPRODUCT, rather than an array formula with SUM,but the choice is yours.--David Biddulph"Ms-Exl-Learner" wrote in ... 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()+3 0)*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! -------------------- (Ms-Exl-Learner) -------------------- "JeffK" wrote: I have a formula:=SUMIF(F8:F10000,"<="&TODAY()+30,G8:G1 0000)-SUMIF(F8:F10000,"<"&TODAY(),G8:G10000) That I'd like to put a condition on that it will only sum if A8:A10000 = "Approved"