Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count blanks by date
I have a table that has meter# , date, and usage in colums A, B and C.
I use a formula =sumif($B$11:$B1000,"="[date],$C$11:$C1000) to total up the amount of usage for each day. But what I want to do is count the number of blanks in column C for each date. So "if $B$11:$B1000,"="[date] then countblank($C$11:$C1000)" is kind of what I'm shooting for but I can't wrap my brain around how to do it. I would like to report that on 4/1 we had 1,912 usage and 4 meters did not report (were blank). Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count if for blanks with 'or' | Excel Worksheet Functions | |||
how to count blanks before today's date? | Excel Worksheet Functions | |||
Count Blanks | Excel Discussion (Misc queries) | |||
Count the blanks | Excel Worksheet Functions | |||
Count blanks cells | New Users to Excel |