Share via

problem for formula

Anonymous
2020-04-17T07:59:37+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-04-17T09:29:12+00:00

    Press Windows key+r - Type intl.cpl and Enter - Post the screenshot

    Click Additional setting - Post the screenshot

    Hence, 2 screenshots are required.

    0 comments
  2. Anonymous
    2020-04-17T09:32:44+00:00

    Press Windows key+r - Type intl.cpl and Enter - Post the screenshot

    Click Additional setting - Post the screenshot

    Hence, 2 screenshots are required.

    0 comments
  3. Anonymous
    2020-04-17T09:35:23+00:00

    Your list separator is semi colon. Change it to either comma or use semi colon in place of comma in your formula. If you keep it semi colon, use below formula (see I have replaced all commas with semi colons)

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

    0 comments
  4. Anonymous
    2020-04-17T10:08:34+00:00

    thanks a  lot, the formula is correct!!

    0 comments
  5. Anonymous
    2020-04-17T10:41:01+00:00

    Great! I am glad that worked! If you don't have any more questions, feel free to choose a rating and have a great day!

    0 comments