Thread
:
I have a complicated formula that I need SERIOUS help with please!
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
I have a complicated formula that I need SERIOUS help with please!
What and how is the cell shaded? Manual, conditional formatting, macro?
--
Don Guillett
SalesAid Software
"Thrlckr" wrote in message
...
Hi,
I am trying to count cells in a row that either contain a "1" or are
"blank," but some of the cells in the row are shaded. The problem that I
am
having is that I cannot make the formula work where it counts and adds up
all
the "1's" and "blank" cells, but not the "shaded" cells. The other
problem
is that sometimes the shaded cells do contain a "1" in it, but I still do
not
want that cell counted.
If someone can PLEASE help me with this, I would greatly appreciate it!
Sincerely,
Carol
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett