problem for formula

Question

I'm going to grouping my data with countif

but what the things happen is i type =countif({i select the data},">2)

it just tell me there is a problem with this formula

and does any one know ho to find key in the time with 1 hour in the criteria, if the time i use is 00:00:00

Answer 1

Hello Phey

I am V. Arya, Independent Advisor, to work with you on this issue. Your formula is allright. Most likely reason may be that comma separator may not be right separator.

Press Windows key+r - Type intl.cpl and Enter - Additional settings - Check what is the list separator here.

For time count query, you can use following type

=COUNTIF(A2:A10,">"&--"02:45:55")

=COUNTIF(A2:A10,">"&TIME(2,45,55))

Answer 2

Thank for the reply, but i still can't get the right formula

if my thing is like this, i need to find the volume of car in 1 hour as example 21:00:00 to 22:00:00

is my formula correct?

Answer 3

Thank for the reply, but i still can't get the right formula

if my thing is like this, i need to find the volume of car in 1 hour as example 21:00:00 to 22:00:00

is my formula correct?

Answer 4

For between following formula (no need for seconds in your case -

=COUNTIFS(A2:A10,">="&--"21:00",A2:A10,"<="&--"22:00")

Answer 5

For between following formula (no need for seconds in your case -

=COUNTIFS(A2:A10,">="&--"21:00",A2:A10,"<="&--"22:00")

now i realize my excel can't do any formula with countif... what should i do? uninstall it and reinstall?