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.
|