count how many tims a certain value occurs

		Microsoft Office Forums > Microsoft Excel > Excel
count how many tims a certain value occurs

03-26-2012, 03:06 AM

Colin Legg Colin Legg is offline

Windows 7 32bit count how many tims a certain value occurs

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

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.

Attached Files

Book1.xlsx (10.6 KB, 15 views)

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:43 AM.