| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count without SUMPRODUCT | Excel Worksheet Functions | |||
| SUM, COUNT and SUMPRODUCT | Excel Worksheet Functions | |||
| sumproduct to count two arguments | Excel Worksheet Functions | |||
| SUMPRODUCT COUNT DATE | Excel Discussion (Misc queries) | |||
| Count if and Sumproduct | Excel Discussion (Misc queries) | |||
Hybrid Mode
