count how many tims a certain value occurs

Colin Legg · #1 03-26-2012, 02:45 AM

I believe the COUNTIFS function is available in Excel 2008, so something like this should work:

=COUNTIFS(F1:T1,"*practiceTime",F2:T2,">0")

We're applying two conditions with this formula. The first condition is that the cell in the header row F1:T1 must contain the word practiceTime. The second condition is that the cells in the data row F2:T2 must contain a value greater than 0.

lucnijs · #2 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 · #3 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.

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