Counting cells with multiple complex criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Counting cells with multiple complex criteria

12-03-2012, 02:09 AM

macropod

Windows 7 64bit Counting cells with multiple complex criteria

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,512

Hi TishyMouse,

To count the conditionally-coloured cells, use the same knid of formula you used for conditionally formatting them.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ranking with multiple criteria	angie.chang	Excel	0	08-14-2012 04:49 PM
Change values in cells based on criteria	SaneMan	Excel Programming	2	02-02-2012 07:58 AM
Selecting blank cells in criteria	apolloman	Excel	6	08-24-2011 05:38 AM
How to count cells containing data and meet certain criteria	AdamNT	Excel	1	08-11-2006 11:51 PM
Multiple criteria in SUMIF?	pumpkin head	Excel	1	02-17-2006 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:17 PM.