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?

 

[Fluff]

How about

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

 

[dreid1011]

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?

Perhaps this:

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

 

[Sunshine8790]

@Fluff @dreid1011
Thank you both! that worked.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Sunshine8790]

I'm sorry - I missed something in my goal for the formula.

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

I need this to count the -'s in Column V, IF column R contains "S", and Column P contains a number between 0 and 1, and not include counts if column Q is Inactive.
Sorry, I know it's a lot.

 

[Fluff]

Try

=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]

Try

=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 gives me a count of 0 which is incorrect

 

[dreid1011]

This gives me a count of 0 which is incorrect

Slight modification to Fluff's formula perhaps:

=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]

Slight modification to Fluff's formula perhaps:

=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 still gives a count of 0.