Posted to microsoft.public.excel.programming

Alan M

external usenet poster

Posts: 69

CountIf function query

Hi,

Is it possible to use the CountIF function to return the number of cells in
a specific range which have a particular interior colour regardless of the
value content of the cell?

If so what information should be used in the 'Criteria' section of the
function wizard?

I have tried putting in .Interior.ClourIndex = 6 but this does not do
anything

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
Countif query	Keith[_3_]	Excel Worksheet Functions	2	February 16th 10 01:43 AM
Mutliple Function Query - probably using Countif	Damo	Excel Worksheet Functions	2	May 13th 09 06:40 PM
COUNTIF function query	Wendy-Bob[_2_]	Excel Worksheet Functions	6	January 21st 09 03:05 PM
COUNTIF function query for multiple colums	Malcolm Gordon	Excel Worksheet Functions	5	April 10th 06 08:10 AM
Microsoft Query rejects "nz" function in Access Query	Vaughan	Excel Discussion (Misc queries)	0	May 4th 05 05:20 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us