Thread: counting blanks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
 
Posts: 661
Default 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