COUNTIF ERROR

[caos88]

Hello everyone,

i am using this formula =COUNTIF('Stored Items'!A:A,"John")+COUNTIF('Stored Items'!B:B,"Boston") to have a count of how many s"John' are in "Boston". When i do that, even if there are only 2, the count is giving me 3 John.....i don't understand where i made the mistake. Should i use a VLOOKUP instead ?

 

[Fluff]

That is giving you a count of Harry & a count of Boston the two are not linked.
It should be
=COUNTIFS('Stored Items'!A:A,"Harry",'Stored Items'!B:B,"Boston")

 

[caos88]

That is giving you a count of Harry & a count of Boston the two are not linked.
It should be
=COUNTIFS('Stored Items'!A:A,"Harry",'Stored Items'!B:B,"Boston")

Hello,

it doesn't really work, is giving me the error : " you have entered too many arguments for this function "

 

[caos88]

That is giving you a count of Harry & a count of Boston the two are not linked.
It should be
=COUNTIFS('Stored Items'!A:A,"Harry",'Stored Items'!B:B,"Boston")

hI @Fluff

i did it, and is working fine. I haven't change nothing so my computer decided to work again.Thank you for the help !!!

 

[Fluff]

You're welcome & thanks for the feedback.