Sum If with two ranges
 

Hi,

I have a SUMIF command relating to a specific range that works.
=SUMIF(E8:E906,V6,O8:O906)

I would like to add a second criteria so that the range is summed if in
addition to the first, (E8:E906 equalling V6) a second criteria is also met.

For example if V6 is met and also H8:H906="LOA" then the range O8:O906 is
summed, if not the value is zero.

I cannot get anything to work!

Thanks for any advice!

Sum If with two ranges
 

Hi

You need a SumProduct formula:

=SUMPRODUCT(--(E8:E906=V6),--(H8:H906="LOA"),O8:O906)

Regards,
Per

"Portiapuss" skrev i meddelelsen
...
Hi,

I have a SUMIF command relating to a specific range that works.
=SUMIF(E8:E906,V6,O8:O906)

I would like to add a second criteria so that the range is summed if in
addition to the first, (E8:E906 equalling V6) a second criteria is also
met.

For example if V6 is met and also H8:H906="LOA" then the range O8:O906 is
summed, if not the value is zero.

I cannot get anything to work!

Thanks for any advice!

Sum If with two ranges
 

Try this

=SUMPRODUCT((E8:E906=V6)*(H8:H906="LOA")*(O8:O906) )

Mike

"Portiapuss" wrote:

Hi,

I have a SUMIF command relating to a specific range that works.
=SUMIF(E8:E906,V6,O8:O906)

I would like to add a second criteria so that the range is summed if in
addition to the first, (E8:E906 equalling V6) a second criteria is also met.

For example if V6 is met and also H8:H906="LOA" then the range O8:O906 is
summed, if not the value is zero.

I cannot get anything to work!

Thanks for any advice!