dkilby
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
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
Please find attached..
CountIfs.xlsx
CountIfs.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for the help
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")