Monday |
8.5 |
6 |
2.5 |
1 |
4 |
4 |
=countif(b4:f4,">2") |
to count the number of filled
in columns, just highlight the range you want to count, then click the down arrow on the sum symbol and choose count. To count the number of occurances equal to (<, > etc.), use = countif(range,"criteria") Be sure and put quote marks around
the criteria |