count how many tims a certain value occurs

lucnijs · #1 03-26-2012, 02:57 AM

Thank you, Colin!
Unfortunately I get an error message again, saying that criteria_range1 is invalid.

luc

Colin Legg · #2 03-26-2012, 03:06 AM

Quote:

Unfortunately I get an error message again, saying that criteria_range1 is invalid.

Did you make any changes to the formula I posted? I've attached example which uses it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use of MIN and count function together	khokababu	Excel	0	02-22-2012 09:40 AM
Count If Formula	beb1227	Excel	10	06-19-2011 11:19 AM
Count By Color	beb1227	Excel	4	06-15-2011 08:46 AM
Count in Excel	zanat0s	Excel	3	06-09-2011 10:53 AM
How to Count from Different Cells?	Shahzad	Excel	3	06-26-2010 01:06 AM