SUMIF statement with AND statement

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"
 
P

Pete_UK

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
 
Top