count if or sumproduct?
 

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)

count if or sumproduct?
 

=sumproduct((a2:a22="myproduct")*(b2:b22="mycode") )

--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
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)

count if or sumproduct?
 

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

"Don Guillett" wrote:

=sumproduct((a2:a22="myproduct")*(b2:b22="mycode") )

--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
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)

count if or sumproduct?
 

ranges gotta be the same size


--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
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

"Don Guillett" wrote:

=sumproduct((a2:a22="myproduct")*(b2:b22="mycode") )

--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
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)

count if or sumproduct?
 

many thanks Don

"Don Guillett" wrote:

ranges gotta be the same size


--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
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

"Don Guillett" wrote:

=sumproduct((a2:a22="myproduct")*(b2:b22="mycode") )

--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
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)

count if or sumproduct?
 

Glad to help

--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
many thanks Don

"Don Guillett" wrote:

ranges gotta be the same size


--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
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

"Don Guillett" wrote:

=sumproduct((a2:a22="myproduct")*(b2:b22="mycode") )

--
Don Guillett
SalesAid Software

"Suddes" wrote in message
...
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)