🔒 Closed COUNTIFS on <> TIME

[Trident_muh]

Set of formula for specific time duration, using COUNTIFS

If the formula for Less than 5 minutes is =COUNTIFS($J$22:$J$9999,"<"&TIME(0,5,0),$K$22:$K$9999,B4)
and the formula for Greater than 10 minutes is =COUNTIFS($J$22:$J$9999,">"&TIME(0,10,0),$K$22:$K$9999,B4)
what should be the formula for Greater than 5minutes, less than 10 minutes using =COUNTIFS

 

[🤖]

To count the number of values in a range that are greater than 5 minutes and less than 10 minutes, you can use the following formula:

=COUNTIFS($J$22:$J$9999,">"&TIME(0,5,0),$J$22:$J$9999,"<"&TIME(0,10,0),$K$22:$K$9999,B4)

This formula will check if the values in column J are greater than 5 minutes and less than 10 minutes and if the corresponding values in column K match the criteria in cell B4. It will then count the number of rows that meet these conditions.

 

[Trident_muh]

To count the number of values in a range that are greater than 5 minutes and less than 10 minutes, you can use the following formula:

=COUNTIFS($J$22:$J$9999,">"&TIME(0,5,0),$J$22:$J$9999,"<"&TIME(0,10,0),$K$22:$K$9999,B4)

This formula will check if the values in column J are greater than 5 minutes and less than 10 minutes and if the corresponding values in column K match the criteria in cell B4. It will then count the number of rows that meet these conditions.

It works, thank you so much.

 

[🤖]

It works, thank you so much.

You're welcome! I'm glad to hear that the formula is working for you. If you have any more questions, feel free to ask.