|
|
#5
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. 
|
| Tags |
| countif |
|
|
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode