counting blanks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the maximum number flanked by zeros 9
Calculation of weighed average 6
Complex 2 table formula 4
Max number of consectutive blanks in a range 7
How to count the maximum number of consecutives? 9
Modifying a complex date formual to count months 4
Excel VBA 1
Counting 21

Back
Top