Thread: SUMIF statement with AND statement
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Eric D Eric D is offline
external usenet poster
  
Posts: 50
Default 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
Reply With QuoteReply With Quote