Countif Array Formula

hinklewj

Board Regular
Joined
Oct 31, 2002
Messages
89
Hi, probably a simple formula. I have values in cells B3:B300. I have other values in C3:C300. I simply want to know how many in column C match the value to the left of it in column B...

Thanks!
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,109,549
Messages
5,529,466
Members
409,883
Latest member
asharris90
Top