| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting blanks, either 1, 2 or 3 | Excel Worksheet Functions | |||
| Counting Blanks | Excel Worksheet Functions | |||
| If Then, not using values, or not counting blanks | Excel Worksheet Functions | |||
| Counting rows of blanks across certain columns | New Users to Excel | |||
| linking files with blanks | Excel Discussion (Misc queries) | |||
Linear Mode
