Posted to microsoft.public.excel.worksheet.functions

alm09

external usenet poster

Posts: 7

sumif function by colors

Is there a way that I can sum up cells in column A by colors? For example,
suppose I have a list of numbers in cells A1:A15. Cells A1, A3, A5, and A10
are colored light yellow. I would like to see a number in cell B1 that sums
up all cells in A1:A15 that are colored light yellow.

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
Need some comments on my Utility_Move class module.	jchen	Excel Worksheet Functions	0	August 21st 06 07:05 PM
Using the TODAY() function in a SUMIF function	JPB	Excel Worksheet Functions	4	July 27th 06 04:01 PM
Can I add and IF function to a SUMIF function?	adscrim	Excel Worksheet Functions	4	January 21st 06 12:32 PM
SUMIF function	yak10	Excel Worksheet Functions	0	February 12th 05 05:12 PM
SUMIF function	yak10	Excel Worksheet Functions	3	February 12th 05 01:15 AM

All times are GMT +1. The time now is 09:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us