Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how copy formula that contains ranges so ranges do not overlap | Excel Worksheet Functions | |||
HELP ON AGE RANGES | Excel Worksheet Functions | |||
Ranges | New Users to Excel | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Sum ranges | Excel Worksheet Functions |