countif when using multiple columns

Copper Contributor

Please help :)


I'm trying to use COUNTIF to understand how many instances of a particular value their are in a range (eg V2:Y500)

 

For example
=COUNTIF('cleaned data inc ing 1000)'!V:AB,”Dry food”)

 

but the formula is only counting the values in the first column of the range - in this example, V - and ignoring anything in columns W to AB. What am I doing wrong..!!?? Have tried googling but nothing seems to make sense! 

 

thank you

2 Replies
If this formula are for a German Sheet
German =ZÄHLENWENN(Tabelle1!C2:C6;Tabelle2!B2)
English =COUNTIF(Sheet1!C2:C6;Sheet2!B2)

This is how it should work unless you want to do something else.

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)

@isabel165 

If you enter Dry Food in any empty cell, let say A1, and in another cell

=A1='cleaned data inc ing 1000)'!AB87

does it return TRUE or FASLE assuming same text shall be in AB87?