How to do summation with 2 conditions?

**Lewis Koh** · 04-18-2010, 10:09 AM

=SUMIF(E55:E118,"Long",AA55:AA118)

**johncena** · 04-18-2010, 10:23 AM

completely not clear.your formula has only one condition.try this with Ctrl+Shift+Enter

{=SUM(IF(E55:E118,"Long",(IF(E55:E118,"short",AA55:AA118))))}

**stanleydgromjr** · 04-18-2010, 10:27 AM

Lewis Koh,

Your formula works for me:
=SUMIF(E55:E118,"Long",AA55:AA118)

You could also try:
=SUMPRODUCT(--($E$55:$E$118="Long"),--($AA$55:$AA$118))

What is the second condition?

**arthurbr** · 04-18-2010, 11:17 AM

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.