LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default Is it possible to combine countif and countcolor?

I have a range of cells and I need to count how many
have a blue background and a cell value of "C" and how
many have a green background and a cell value of "C"

I can count all the cells in the range that are blue or
green and I can count all the cells that contain the
value of "C", but how can I count the combined
criteria?

I'm thinking I just need some algebraic help... :-S

 
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
How to combine an AND and a COUNTIF Michael T Charts and Charting in Excel 4 February 1st 09 12:29 PM
Sum + countcolor Opal Excel Programming 2 October 6th 08 09:36 PM
Can I combine CountIf with IF or AND? Gmolatore Excel Discussion (Misc queries) 5 April 24th 08 03:55 AM
countcolor Pascal Excel Worksheet Functions 1 August 22nd 06 02:34 PM
Do I need to combine hlookup and countif????? sharkh Excel Worksheet Functions 2 August 17th 06 05:05 PM


All times are GMT +1. The time now is 10:00 PM.

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

About Us

"It's about Microsoft Excel"