Formulas for Adding

  • Thread starter Thread starter Shannan
  • Start date Start date
S

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?
 
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
 
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
 
Back
Top