# Count cells with multiple criteria

1. ## Count cells with multiple criteria

Hi forum,

Here we go... I have another headache...

I have a column O called Call Score for which I only want to count scores that are less than 70, but only if the date column N is 4/1, 4/2, 4/3, 4/4 and 4/5.

There, I am clueless...

2. ## Re: Count cells with multiple criteria

Try

=COUNTIFS(scores,">70",dates,">="&DATE(2009,4,1),dates,"<="&DATE(2009,4,5))

3. ## Re: Count cells with multiple criteria

This looks similar to the help I require. May I ask what I'd type should I want it to select the same but for the entire month of May? (rather than the individual dates specified above).

4. ## Re: Count cells with multiple criteria

This is absolutely awesome! It worked!

Forum moderators, this is the best help I have ever had in my professional career.

I have learned more about Excel in just 3 weeks than my entire work years. Thanks again!!!

5. ## Re: Count cells with multiple criteria

Try =COUNTIFS(scores,">70",dates,">="&DATE(2009,5,1),dates,"<="&DATE(2009,5,31))

scores in small caps is actually a column
dates in small caps is actually a column as well

good luck!

7. ## Re: Count cells with multiple criteria

no problem... I ask a lot of questions to the forum so I think it was nice to help someone figure out those formulas...

Fyi - Microsoft website has a how-to section that is Ok. It helps identify what formula(s) are good for waht you want to accomplish. But then to find out the content of the argument, after you've tried figuring it out on your own, your best bet is the forum.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1