Variations on Sumif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
try this
=SUM(IF($E$14:$E$17="sell",IF($I$14:$I$17="call",$J$14:$J$17,0),0))

after you paste into cell press ctrl + shift + enter
 
Back
Top