Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding next row of formulas | New Users to Excel | |||
Adding formulas | Excel Discussion (Misc queries) | |||
Adding formulas across Worksheets | Excel Worksheet Functions | |||
Adding formulas | Excel Worksheet Functions | |||
Why are my formulas not adding up automatically | Excel Worksheet Functions |