Countifs Help needed

Daffyduck

New Member
Joined
Mar 18, 2019
Messages
1
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
 

Some videos you may like

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
Joined
Aug 18, 2015
Messages
10,216
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.
 

Watch MrExcel Video

Forum statistics

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

This Week's Hot Topics

Top