SUMIF statement with AND statement

  • Thread starter Thread starter Eric D
  • Start date Start date
E

Eric D

Can anyone tell me how to use a SUMIF statement with a AND statement?

I need it to sum e3 when d3="in repay" except for when c3="consolidation"
 
Try it this way:

=SUMPRODUCT((D3:D100="in repay")*(C3:C100<>"consolidation)*(E3:E100))

Adjust ranges to suit, but you can't use full-column ranges in
versions before XL2007.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF: How to add some cells and ignore other cells in a row 2
Multiple critera with in a sumif statement 5
SUMIFS 8
sum multiple columns with SUMIF or SUMPRODUCT 2
SUMIF not adding a range 1
Help with if statement 4
Can an If statement return a formula for false? 1
Does anyone have aformula for Weeks Supply? 1

Back
Top