Countifs statement checking for number of red cells under 2 conditions

**alinda** · 10-03-2011, 06:35 AM

Hi all,

One more try ;-).
For three weeks now, I am struggling with the same issue.
I need Excel to calculate the number of red cells for 19 identified colums. These columns are color coded by hand - based on the question whether a deadline for a task was met. .

The counting however, should take Criteria BG 1,2,3 or 4, and Criteria "selected launch window" into account. I tried to do this with a countifs formula, but I do not know how to put in the "criteria" for the color counting.

Could you please help me?

Thanks, Alinda

**daddylonglegs** · 10-03-2011, 06:54 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this

**incjourn** · 10-03-2011, 07:45 AM

Something like this...

Please Login or Register  to view this content.

Countifs statement checking for number of red cells under 2 conditions

LinkBack

Thread Tools

Rate This Thread

Display

Countifs statement checking for number of red cells under 2 conditions

Re: Countifs statement checking for number of red cells under 2 conditions

Re: Countifs statement checking for number of red cells under 2 conditions

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions