sumproduct

  • Thread starter Thread starter Opal
  • Start date Start date
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!
 
Hi smartin,

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