Countifs Help

[Sunshine8790]

Maybe I'm just using the wrong formula, but my current formula is:

=COUNTIFS('Main Sheet'!V:V,"-",'Main Sheet'!R:R,"S")

This is counting the amount of cells on another sheet that contain a "-" symbol in column V, if Column R contains an "S".

This works - however, I also need the formula to not include counts if Column Q contains "Inactive".
How do I do this?

 

[dreid1011]

This still gives a count of 0.

Are the values 1 or 0 or decimals in between?

 

[Sunshine8790]

Are the values 1 or 0 or decimals in between?

Just plain values. No decimals.

 

[dreid1011]

Just plain values. No decimals.

This then:

=COUNTIFS('Main Sheet'!V:V,"-",'Main Sheet'!R:R,"S",'Main Sheet'!Q:Q,"<>Inactive",'Main Sheet'!P:P,">=0",'Main Sheet'!P:P,"<=1")

 

[Sunshine8790]

This then:

=COUNTIFS('Main Sheet'!V:V,"-",'Main Sheet'!R:R,"S",'Main Sheet'!Q:Q,"<>Inactive",'Main Sheet'!P:P,">=0",'Main Sheet'!P:P,"<=1")

This worked! You ROCK, thank you!

 

[dreid1011]

This worked! You ROCK, thank you!

I am happy to help, and glad that worked.