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