SUMIF statement with AND statement
 

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

SUMIF statement with AND statement
 

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

On Jul 14, 6:58*pm, Eric D wrote:
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"
--
Eric

SUMIF statement with AND statement
 

thanks pete, this works great
--
Eric


"Eric D" wrote:

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