SUMIF Question

M

mksullvn

I am wondering how to sum numbers in one column where the text is red
excluding text that is not red. I have tried various functions bu
none seem to work
 
P

Paul B

mksullvn, have a look at Chip's site here

http://www.cpearson.com/excel/colors.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
M

mzehr

Hi,
Without having more information:
It will depend on whether the text is red because of
conditional formatting. If so you will need to replicate
the if condition that is causing it to be red, and you
will need a sumif(EvaluationRange,Condition,SumRange)
equation.
For example:
=SUMIF(A1:A4,">"&TODAY(),B1:B4)
will return the sum of all cells in B1:B4 which have a
date greater than today.


Otherwise see:
http://cpearson.com/excel/colors.htm
http://www.xldynamic.com/source/xld.ColourCounter.html
 
Top