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!