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 -