Link to home
Start Free TrialLog in
Avatar of dkilby
dkilbyFlag for Canada

asked on

Excel + CountIfs + two colums

I have two columns

1st column has dates
2nd column has numbers from 0 to 11

I have two fields on a Start Date and End Date where user can enter dates, I want to then search the data tab and count the number or rows where the number in column B is less than 4, greater than 8, and between 4 and 8

how would I do this

See attached example
Book1.xlsx
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Less Than 4              =COUNTIFS(Data!A:A, ">=" & B1, Data!A:A, "<=" & B2, Data!B:B, "<4")
Greater Than 8        =COUNTIFS(Data!A:A, ">=" & B1, Data!A:A, "<=" & B2, Data!B:B, ">8")
Between 4 and 8     =COUNTIFS(Data!A:A, ">=" & B1, Data!A:A, "<=" & B2, Data!B:B, ">=4", Data!B:B, "<=8")
Please find attached..
CountIfs.xlsx
SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dkilby

ASKER

thanks for the help