Dec 04 2020 10:15 AM
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
Dec 04 2020 10:57 AM
Dec 04 2020 11:41 AM
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?