SUM IF Help needed

  • Thread starter Thread starter patidallas22
  • Start date Start date
P

patidallas22

I want to use two different arguments in getting a sum. I thought
could use SUMIF but can't figure it out.

Example below is...I have 3 columns: PO Number; Total PO; Invoice
(Yes/No)

Proj # Total PO Invoiced
3333 $456.00 Yes
3832 $300.00 Yes
3333 $200.00 No

What I need is to put in a formula so it searches for a specific Proj
and only totals the amount if the Invoiced column says "Yes".

Is there a formula that can do this?

Thanks!
Pat
 
one way:

Assume your Proj # is in D1

=SUMPRODUCT(--(A2:A100=D1),--(C2:C100="Yes"),B2:B100)
 
Hi Pati
Turn your back on SUMIF and embrace SUMPRODUCT.
Let the Project Numbers be in A2:A101, the Total PO in the B column, and
Invoices in C

The Proj to find is in D1
Use =SUMPRODUCT(--(A2:A101=D1),--(C2-C101="Yes") , B2:B101)
In front of the first two terms a double negations (2 minus signs) It may be
frowned upon in grammar but it Excel it turns a Boolean array (bunch of
TRUEs and FALSEs) into a numeric array with 1's and 0's
 
Back
Top