Formulas for Adding
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?
|