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))