Won't accept my function

[jpbeenen]

Hi,

In 2013 I'm trying to use this formula =COUNTIFS($K:$K,">=M1","<M2")
But it does not accept my function; keeps saying there's a problem and asking if I'm trying to use a function or just write text.

I think there's nothing wrong with the formula syntax and the cell is formatted as a number.

Please why is it not working?

With kind regards,

Jaspert

 

[jpbeenen]

Hi,

Tnx for sticking with me

innovationservices.ehv.campus.philips.com/sites/default/files/u98/function.png Can you paste this into a browser?

Meanwhile I will investigate the link in your signature

=N1>1 - False
=N2>1 - False
=K2>1 - False to the end

There are no values larger than 1. These are % but then in numbers behind the comma. as in 0,57 meaning 57%

 

[Jonmo1]

I don't see why that wouldn't work.
According to the picture, you're expecting a result of 3 right?

Are the values real numbers?
=ISNUMBER(N1)
=ISNUMBER(N2)
=ISNUMBER(K2) - filled to the end.

?

 

[Jonmo1]

I see it..

Remove the spaces in the quotation marks.
Those were added because of forum compatibility, it tends to treat < and > symbols as html code.

=COUNTIFS($K:$K;">="&N1;$K:$K;"<"&N2)

 

[jpbeenen]

This works!

I actually added the spaces some posts ago because I was asked to add spaces around the >

Really appreciate it!

 

[jpbeenen]

Let me know If I can help you sometime with some knowledge about online marketing or websites

 

[Jonmo1]

You're welcome.

Yeah, the thing about the spaces..
Forum software tends to treat < and > symbols as HTML code, and formulas get cut off.
So we suggest adding spaces around those characters when you post formulas in the forum.

I guess it should be added that those spaces should be removed when you're actually entering the formula in your excel sheet.

 

[jpbeenen]

Hi,

One more Q

What would the formula be for the counting the nr of times a cell is equal to &N3?

Tnx!

 

[Jonmo1]

That would be

=COUNTIF($K:$K;N3)

 

[jpbeenen]

Srry, that would be a simple countif

 

[jpbeenen]

I I see you've answered faster than I could post I thought of it myself hehe.

Tnx! for your very fast response