View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EG EG is offline
external usenet poster
 
Posts: 38
Default Variations on Sumif

Sumif allows you to add numbers in a column IF another cell in the same row
meets a certain criteria.

Question: Can I do this calculation if I have two sets of criteria instead
of just one?

For example:
E14 = Sell, I14 = Call, J14 = 2
E15 = Buy, I15 = Put, J15 = 3
E16 = Sell, I16 = Put, J16 = 4
E17 = Sell, I17 = Call, J17 = 2

I want to add the values in Column J whose same row E value is "sell" and
whose same row I value is "Call". In this case it would be 2+2.

Is this possible??

Thanks,

EG