**Question description:**

*This user has given permission to use the problem statement for this blog.*

in he cell K24 count the number of values in the range B6:K12 greater than 200

Solved by G. E. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
13/04/2018 - 07:30

Hi there!

User
13/04/2018 - 07:30

hello

Excelchat Expert
13/04/2018 - 07:30

I am just creating your formula so you can test - won't be long!

User
13/04/2018 - 07:31

okay thank you

Excelchat Expert
13/04/2018 - 07:31

Give this a try:

Excelchat Expert
13/04/2018 - 07:31

=countif(B6:K12,">200")

User
13/04/2018 - 07:33

it doesnt work

User
13/04/2018 - 07:34

it has a problem with the formula

User
13/04/2018 - 07:34

it is not written correctly

Excelchat Expert
13/04/2018 - 07:34

can you copy the exact formula you have in cell K24?

Excelchat Expert
13/04/2018 - 07:35

Or - if possible share your file so I can take a peek?

User
13/04/2018 - 07:36

i typed in the formula u send me

User
13/04/2018 - 07:36

K24

Excelchat Expert
13/04/2018 - 07:36

Is it returning any values?

User
13/04/2018 - 07:36

no

Excelchat Expert
13/04/2018 - 07:36

are you able to share your sheet at all?

Excelchat Expert
13/04/2018 - 07:38

Maybe copy and paste the formula into the cell instead of manually typing it (if you didn't do that in the first place) and see if it works?

User
13/04/2018 - 07:39

okay let me try

Excelchat Expert
13/04/2018 - 07:39

Sure thing

User
13/04/2018 - 07:39

okay i did that

User
13/04/2018 - 07:40

and it says the formula has a mistake in it

User
13/04/2018 - 07:40

in the K12 part

Excelchat Expert
13/04/2018 - 07:40

you copied exactly this:

Excelchat Expert
13/04/2018 - 07:40

=countif(B6:K12,">200")

Excelchat Expert
13/04/2018 - 07:40

into cell K24?

User
13/04/2018 - 07:41

yes

Excelchat Expert
13/04/2018 - 07:42

Are you able to share your Excel file?

User
13/04/2018 - 07:42

it says i should write range than criteria

Excelchat Expert
13/04/2018 - 07:42

For sure - that's exactly what the formula is doing

Excelchat Expert
13/04/2018 - 07:43

It's so weird I'd love to see your file to see what's up

Excelchat Expert
13/04/2018 - 07:43

the range is B6:K12

Excelchat Expert
13/04/2018 - 07:44

the criteria is ">200"

Excelchat Expert
13/04/2018 - 07:44

and there's a comma between them

Excelchat Expert
13/04/2018 - 07:49

That is definitely the formula that you'd want to use. Feel free to contact us back if you need further assistance anytime and we will help.

Excelchat Expert
13/04/2018 - 07:49

Have a great rest of your day!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*