Excel - COUNT Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.