Multiple count IFs

[dowcraig]

I am trying to do an auto-stats sheet and need some help. We have assigned a value of HIGH and LOW based on a specific set of criteria.

I'm trying to get a formula that will count how many cells apply in the given criteria:

Count the number of sells in range of $Y$7:$Y$2478 that equals the sentence "LOW" but also falls within a specific date range in cells G1 and G2

G1= the beginning date of the range
G2= the end date of the range

Thanks for any help you can provide

 

[barry houdini]

Where are the dates? Assuming those are in column A you can use COUNTIFS like this:

=COUNTIFS($Y$7:$Y$2478,"LOW",$A$7:$A$2478,">="&G1,$A$7:$A$2478,"<="&G2)

 

[dowcraig]

Thanks so much for the info. That really helped.

I'm now looking for a way to count how many things apply to this formula, but have a non-blank cell in column AO7 to AO2506. The non-blank cell would have have words in it, rather than numbers. My research is telling me that's not possible with a COUNTIFS formula, so if it's not, then I'd need to locate the number of cells within that range that have the words Dog or Cat.

Thanks again

 

[barry houdini]

You can use a non-blank condition in COUNTIFS, using the criterion "<>" like this

=COUNTIFS($Y$7:$Y$2478,"LOW",$A$7:$A$2478,">="&G1,$A$7:$A$2478,"<="&G2,$AO$7:$AO$2478,"<>")

extend ranges as required but they all need to be the same size