counting blanks

P

Paul

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
 
T

T. Valko

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
 
Top