Countifs Help needed

[Daffyduck]

I'm sure this has been asked before I need to do a countifs > or = one cell then < or = another cell and and third crietera equals "Yes" This is on office 365 excel when I put the expresion into the cell it just shows the equation. =COUNTIFS(Input!A:A,(">="(Output!C1)),Input!E:E,"Yes") I have tried =COUNTIFS(Input!A:A,(>=(Output!C1)),Input!E:E,"Yes") as well same results anyone have any thoughts on this?

Thanks.
Daffy

 

[Eric W]

Welcome to the Board.

Try:

=COUNTIFS(Input!A:A,">="&Output!C1,Input!A:A,"<="&Output!D1,Input!E:E,"Yes")

Where C1 and D1 are the cells for low and high values.