sumproduct

O

Opal

Hi,
I want to count the number of times the contents of each cell in ColC occur
in column B for each sort in column A.

e.g.
Col A Col B Col C

Oran BK BK
Oran BK HL
Oran JU JU

Gree JU
Gree HL
Gree BK

Help!
 
O

Opal

Hi smartin,

I tried your suggestion but i got only zero(0) answers.
Any thing else i can try?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct, single criteria identified within multiple in single c 4
VLOOKUP reference issue 3
Count max consecutive cells 2
Numbers from first column 5
Counting 3 columns? 2
Unknown # cells need to be in one column - Macro 2
Create Workbooks and Copy Template Worksheet to those Workbooks 12
macro for Excel 2003 to combine and sort data range 5

Top