Is there an Excel formula to sum color filled cells?

  • Thread starter Alfred Kingfisher
  • Start date
A

Alfred Kingfisher

I have an Excel (2003) worksheet where cells are either color filled or not.
Is there a formula that I can use to calculate the current number of cells
that have no color fill?
 
P

prabhuraaman

There is no direct way.But there is an indirect way if you are using
Microsoft Excel 2003

CLIK CTRL+F
CLIK OPTIONS
GO TO THE FORMAT BOX AND SELECT THE CELL HAVING YOUR FORMAT AND CLIK
FIND ALL
When the results are displayed,Select ALL THE RESULTS.
The sum would be highlighted in the STATUS BAR

For more join
http://groups.google.co.in/group/Answers-for-everything
 
Top