=SUMPRODUCT(--(A2:A50=102),--(B2:B50<""))

where A2:A50 is the plant range and B2:B50 reason A range

if you are using X you can change it to

=SUMPRODUCT(--(A2:A50=102),--(B2:B50="X"))

replace 102 with

=SUMPRODUCT(--(A2:A50=H1),--(B2:B50<""))

where you put the plant number in H1



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Booweezie" wrote in message
...
I'm needing to count stuff in a column based on a condition in another
column. Here's my example:

Reasons
Plant A B C D E

102 X
999 X
102 X
102 X

I want to set up a matrix where I count each reason by
Plant.........so.....
For Reason #A - My count for 102 would be 2 and for 999 would be 1
For Reason #C - My count for 102 would be 1 and for 999 would be 0

Does anyone know of a formula to use; I'm stumped.

Thanks.

Booweezie