Auto Sum + Conditional Formatting
Hi
Couldn't you just count the empty cells?
=COUNTIF(A1:A60,""&"")
--
Andy.
"BenJAMMIN" wrote in message
...
I would like to take one cell and have it with the Auto Sum feature.
Here's the catch: I have applied a simple Conditional Formatting to a number
of cells. The formatting is setup for blank formatting: equal to =""
There is nothing between the quotes, which tells the formatting that if
there isnt anything in the cell, then give the cell a color. If ANY value is
placed in the cell, take away the color.
So with that said, is there a way to have the Auto Sum feature add up
those cells and tell me how many that are left that need a value? For
example, if there are 60 cells to begin with, and 32 of them have had a
value placed in them, the Auto Sum cell would display the number 28.
Any ideas on how to get this to work or something similiar?
Thanks
|