View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Valy Greavu Valy Greavu is offline
external usenet poster
 
Posts: 3
Default 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