Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...
=SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650))
or =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650)) |
Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...
The data is like so:
K L M ORG Reason #1 ABQ MC 1 ABQ MC 1 ABQ MC 1 ABQ MC MD 1 ABQ MC MD 1 ABQ MC MD 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ALB MC 1 ALB MC 1 ALB MC MD 1 ALB MC MD 1 ALB NO CONS 1 ALB NO REV CONS 1 ALB NO REV CONS 1 "pgarcia" wrote: =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650)) |
Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...
Hi,
Please let us know what you want to do? Non of the formulas are correct. Thanks, -- Farhad Hodjat "pgarcia" wrote: =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650)) |
Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...
Sorry, I posted the data right after I post this question. I'm trying to find
out how many ABQ has of MC. In the below example ABQ has 3 MC. Does that make since? And thanks for the reply. The data is like so: K L M ORG Reason #1 ABQ MC 1 ABQ MC 1 ABQ MC 1 ABQ MC MD 1 ABQ MC MD 1 ABQ MC MD 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ALB MC 1 ALB MC 1 ALB MC MD 1 ALB MC MD 1 ALB NO CONS 1 ALB NO REV CONS 1 ALB NO REV CONS 1 "Farhad" wrote: Hi, Please let us know what you want to do? Non of the formulas are correct. Thanks, -- Farhad Hodjat "pgarcia" wrote: =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650)) |
Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...
Why not just try them?
The third one works but why are all the ranges absolute except D3? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pgarcia" wrote in message ... The data is like so: K L M ORG Reason #1 ABQ MC 1 ABQ MC 1 ABQ MC 1 ABQ MC MD 1 ABQ MC MD 1 ABQ MC MD 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ALB MC 1 ALB MC 1 ALB MC MD 1 ALB MC MD 1 ALB NO CONS 1 ALB NO REV CONS 1 ALB NO REV CONS 1 "pgarcia" wrote: =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650)) |
Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...
Here's an array formula that should work.
=COUNT((K3:K4650="ABQ")*(L3:L4650="MC")*(M3:M4650) ) Ctrl-Shift-Enter This will return the number of times "ABQ" and "MC" appear in the same row. Adapted from http://www.cpearson.com/excel/ArrayFormulas.aspx HTH, JP On Nov 28, 1:48 pm, pgarcia wrote: The data is like so: K L M ORG Reason #1 ABQ MC 1 ABQ MC 1 ABQ MC 1 ABQ MC MD 1 ABQ MC MD 1 ABQ MC MD 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ALB MC 1 ALB MC 1 ALB MC MD 1 ALB MC MD 1 ALB NO CONS 1 ALB NO REV CONS 1 ALB NO REV CONS 1 "pgarcia" wrote: =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650))- Hide quoted text - - Show quoted text - |
Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...
Read the post to Sandy Mann.
Thanks any ways. "Farhad" wrote: Hi, Please let us know what you want to do? Non of the formulas are correct. Thanks, -- Farhad Hodjat "pgarcia" wrote: =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650)) |
Should this work? =SUMPRODUCT( --($K$3:$K$4650&D3),...
Hi,
Try this: =SUMPRODUCT( --($K$3:$K$4650="ABQ"), --($L$3:$L$4650="MC")) -- Farhad Hodjat "pgarcia" wrote: Sorry, I posted the data right after I post this question. I'm trying to find out how many ABQ has of MC. In the below example ABQ has 3 MC. Does that make since? And thanks for the reply. The data is like so: K L M ORG Reason #1 ABQ MC 1 ABQ MC 1 ABQ MC 1 ABQ MC MD 1 ABQ MC MD 1 ABQ MC MD 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ABQ NO REV CONS 1 ALB MC 1 ALB MC 1 ALB MC MD 1 ALB MC MD 1 ALB NO CONS 1 ALB NO REV CONS 1 ALB NO REV CONS 1 "Farhad" wrote: Hi, Please let us know what you want to do? Non of the formulas are correct. Thanks, -- Farhad Hodjat "pgarcia" wrote: =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), --($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650&D3), --($L$3:$L$4650&$F$2), ($M$3:$M$4650)) or =SUMPRODUCT( --($K$3:$K$4650=D3), --($L$3:$L$4650=$F$2), --($M$3:$M$4650)) |
All times are GMT +1. The time now is 10:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com