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.
