count if or sumproduct?

S

Suddes

I have a list of brands in column C and I have a code in column M I want to
be able to count the number of times a brand appears with a particular code
associated to it (the codes can be both numbers or letters)
 
S

Suddes

Thanks for the quick repy Don, i used your formula onlysubstituting my
columns ie
=SUMPRODUCT((C2:C2000="Ariel")*(M1:M2000="A"))

But this returned #NA
any ideas?

thanks
 
Top