Posted to microsoft.public.excel.misc

Mr. Low[_2_] Mr. Low[_2_] is offline

external usenet poster

Posts: 1

Excel 2007: Can it SUMIF( ) using color as a condition ?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumif with a second condition	jewel	Excel Worksheet Functions	6	September 5th 08 07:46 PM
excel 2007 - change fill color from one color to another	okiedokiedoo	Excel Discussion (Misc queries)	1	December 30th 07 10:25 PM
sumif with or< condition	Will Fleenor	Excel Worksheet Functions	8	April 27th 07 07:45 AM
SUMIF function with text color condition	MrWallyWorld	Excel Worksheet Functions	4	August 18th 06 04:05 AM
sumif on more than one condition	steve alcock	Links and Linking in Excel	4	May 13th 05 01:53 PM

All times are GMT +1. The time now is 11:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us