Formulas for Adding

[Shannan]

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?

 

[FSt1]

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

 

[Gord Dibben]

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