CountIfs Formula between two criteria

jihopark10

I am trying to do a formula that will pick up the tester and also if it is between a set of range of dates. I did one formula picking up the name, and one doing the set of dates. When I combine the two, I am not able to get it to work. Could someone tell me what I am doing wrong.

I am hoping this formula will show the number of tests under the user within the range date of 3/29 and 4/5

=COUNTIFS({Test Tracker Range 1}, "User Name", AND(({Test Tracker Range 3}, >=DATE(2026, 3, 29), {ITC1 Test Tracker Range 3}, <=DATE(2026, 4, 5))))

Gillian C

Hi @jihopark10

I think it should work if you change your formula to

=COUNTIFS({Test Tracker Range 1}, "User Name", {Test Tracker Range 3}, >=DATE(2026, 3, 29), {ITC1 Test Tracker Range 3}, <=DATE(2026, 4, 5))

That fits with the Countif formula structure of Range, Criterion, Range 1, Criterion 1, Range 2, Criterion 2…

Hopefully it help :)

Kind Regards

Gillian