Posted to microsoft.public.excel.worksheet.functions

GCC

external usenet poster

Posts: 12

can I add values of cells that are certain colours?

I was wondering if it was possible to write a formula in excel that says for
example 'add the numbers in all cells that are coloured purple?'

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
average values in non-contiguous cells, ignoring 0 values	RWormdahl	Excel Worksheet Functions	3	October 30th 06 01:06 AM
How to add comments/colours to cells in a protected sheet	Nousj	Excel Discussion (Misc queries)	2	June 21st 06 01:58 PM
Create conditional IF to format cells using 6 different colours	NZJen	Excel Worksheet Functions	2	August 17th 05 03:41 PM
Adding cells by colours	whatzzup	Excel Discussion (Misc queries)	1	August 17th 05 01:02 PM
Excel 2003 font colours and cell colours	bretta	Excel Discussion (Misc queries)	1	April 17th 05 03:45 AM

All times are GMT +1. The time now is 10:03 AM.

About Us

"It's about Microsoft Excel"