Posted to microsoft.public.excel.misc
|
|
Excel 2007: Can it SUMIF( ) using color as a condition ?
Try this:
http://valygreavu.wordpress.com/2010...ful-solutions/
--
Valy Greavu
MCP, MOS Expert
"Mr. Low" wrote:
Hi,
I understand that Excel 2007 can sort by colors. It is a great feature indeed.
May I know if =SUMIF( ) could use a color as the condition to sum up color
shaded cells or cells with certain font color?
Thanks
Low
|