# Countifs Help needed

#### Daffyduck

##### New Member
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

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### Eric W

##### MrExcel MVP
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.

Replies
5
Views
52
Replies
9
Views
285
Replies
7
Views
137
Replies
0
Views
48
Replies
1
Views
69

1,108,788
Messages
5,524,879
Members
409,609
Latest member
Channingz