Add up as in SUM or as in COUNT?

If you have Excel 2007 you can sum by color.

Elsewise you would need a VBA function.

For the second part...............

=COUNTA(range)-COUNT(range)

Counts the filled cells in whole range then subtracts the cells with
numbers.

Note: Dates are considered numbers.


Gord Dibben MS Excel MVP

On Wed, 30 Sep 2009 14:25:01 -0700, Shannan
wrote:

Is there a way to tell excel to add up all of the cells in a row that have
been filled in with a certain color?

Also, is there a way to tell excel to add up all of the cells in a column
that have writing (text not numbers) in them?