counting blanks
 

Hi I need to count cells in columns that have numbers in them. Can someone
help with formula please?
Example
1
0
3
5
0
0
i have maximum 48 rows in a column and i need the number of filled cells
multiplied by 15 minutes for each instance. In the above case it should
return 45 minutes. Help would be greatly appreciated.
Paul

counting blanks
 

My best guess:

Format as h:mm for a result of 0:45

=COUNTIF(A$1:A$6,"0")*TIME(0,15,0)

Format as GENERAL for a result of 45

=COUNTIF(A$1:A$6,"0")*15

Biff

"Paul" wrote in message
...
Hi I need to count cells in columns that have numbers in them. Can someone
help with formula please?
Example
1
0
3
5
0
0
i have maximum 48 rows in a column and i need the number of filled cells
multiplied by 15 minutes for each instance. In the above case it should
return 45 minutes. Help would be greatly appreciated.
Paul