| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct
Hi, I have a formula looks like
this:=SUMPRODUCT(--(M15:M252=J158),(L15:L252))+SUMPRODUCT(--(M15:M252=J158),(N15:N252)) How do I simplify to sum L15:L252 and N15:N252 Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumproduct
As long as L15:L252 and N15:N252 contain numbers only.
=SUMPRODUCT(--(M15:M252=J158),L15:L252+N15:N252) -- Biff Microsoft Excel MVP "freebee" wrote in message ... Hi, I have a formula looks like this:=SUMPRODUCT(--(M15:M252=J158),(L15:L252))+SUMPRODUCT(--(M15:M252=J158),(N15:N252)) How do I simplify to sum L15:L252 and N15:N252 Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumproduct
Hi, thanks. My previous formula followed by:
-SUMPRODUCT(--(G15:G252="return"),--(E15:E252=J166),--(k15:k252="vender A),D15:D252+n15:n252) It did not work. I want a simplified formula to do if first 2 -- met, sum D15:D252, if last -- met, sum n15:n252. Thanks. "T. Valko" wrote: As long as L15:L252 and N15:N252 contain numbers only. =SUMPRODUCT(--(M15:M252=J158),L15:L252+N15:N252) -- Biff Microsoft Excel MVP "freebee" wrote in message ... Hi, I have a formula looks like this:=SUMPRODUCT(--(M15:M252=J158),(L15:L252))+SUMPRODUCT(--(M15:M252=J158),(N15:N252)) How do I simplify to sum L15:L252 and N15:N252 Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumproduct
I want a simplified formula to do if first 2 -- met,
sum D15:D252, if last -- met, sum n15:n252. Sorry, I don't understand what you mean. My best guess is that those are 2 separate conditions and you need to do it the way you originally had it: -- Biff Microsoft Excel MVP "freebee" wrote in message ... Hi, thanks. My previous formula followed by: -SUMPRODUCT(--(G15:G252="return"),--(E15:E252=J166),--(k15:k252="vender A"),D15:D252+n15:n252) It did not work. I want a simplified formula to do if first 2 -- met, sum D15:D252, if last -- met, sum n15:n252. Thanks. "T. Valko" wrote: As long as L15:L252 and N15:N252 contain numbers only. =SUMPRODUCT(--(M15:M252=J158),L15:L252+N15:N252) -- Biff Microsoft Excel MVP "freebee" wrote in message ... Hi, I have a formula looks like this:=SUMPRODUCT(--(M15:M252=J158),(L15:L252))+SUMPRODUCT(--(M15:M252=J158),(N15:N252)) How do I simplify to sum L15:L252 and N15:N252 Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumproduct
How about this array formula
=SUM(IF((G15:G252="return")*(E15:E252=J166),D15:D2 52,IF((E15:E252=J166)*(K15:K252="vender A"),N15:N252))) -- __________________________________ HTH Bob "freebee" wrote in message ... Hi, thanks. My previous formula followed by: -SUMPRODUCT(--(G15:G252="return"),--(E15:E252=J166),--(k15:k252="vender A"),D15:D252+n15:n252) It did not work. I want a simplified formula to do if first 2 -- met, sum D15:D252, if last -- met, sum n15:n252. Thanks. "T. Valko" wrote: As long as L15:L252 and N15:N252 contain numbers only. =SUMPRODUCT(--(M15:M252=J158),L15:L252+N15:N252) -- Biff Microsoft Excel MVP "freebee" wrote in message ... Hi, I have a formula looks like this:=SUMPRODUCT(--(M15:M252=J158),(L15:L252))+SUMPRODUCT(--(M15:M252=J158),(N15:N252)) How do I simplify to sum L15:L252 and N15:N252 Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| IF / SUMPRODUCT HELP | Excel Worksheet Functions | |||
| SUMPRODUCT | Excel Discussion (Misc queries) | |||
| sumproduct | Excel Discussion (Misc queries) | |||
| sumproduct | Excel Worksheet Functions | |||
Linear Mode
