Try

=SUMPRODUCT(--($B$11:$B1000=[date]),--(ISBLANK($C$11:$C1000)))

--

HTH

Bob

"Molasses26" wrote in message
...
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!