Thread: [Solved] count how many tims a certain value occurs
View Single Post
 
Old 03-26-2012, 02:45 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default
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.
Reply With Quote