ExcelBanter - sumproduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sumproduct (https://www.excelbanter.com/excel-discussion-misc-queries/196044-sumproduct.html)

freebee

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.

T. Valko

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.

freebee

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.

T. Valko

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.

Bob Phillips[_3_]

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.

All times are GMT +1. The time now is 09:30 PM.