Formulas for Adding
 

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?

Formulas for Adding
 

hi
first question.
excel has no built in function to do this but it is possible with a UDF.
see this site for code to do this.
http://cpearson.com/excel/colors.htm
second question.
i don't think you can add text but you can count.
read up on the counta function in excel help.

regards
FSt1

"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?

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?