LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"