P
Portiapuss
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!
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!