Thread: if and sum, 2nd try.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default if and sum, 2nd try.
=sumproduct((I13:I36 ="v")*(H13:H36 ="in")*G13:G36)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Christy" wrote in message
...
This is what I have:
Col G Col H Col I
15 in v
20 ot v
30 in n
This is what I need to do:
When I13:I36 = v AND H13:H36 = in, THEN add G13:G36
Thanks for your help
Christy

Reply With QuoteReply With Quote