kdjonesmtb
New Member
- Joined
- Feb 5, 2010
- Messages
- 31
I have found that when I am using Countif vs the sort filter in Excel; the countif statement if giving me results that are not counting all the values in a column
For example
=COUNTIF(R2:R480,"Y")
is returning a value of 80 when I use a Sort Filter of "Y" i get a result of 271
Do I need to TRIM or CLEAN the values in my column to get a more accurate result from Countif?
Is there a better formula to determine how many "Y" are in a column?
Thanks
For example
=COUNTIF(R2:R480,"Y")
is returning a value of 80 when I use a Sort Filter of "Y" i get a result of 271
Do I need to TRIM or CLEAN the values in my column to get a more accurate result from Countif?
Is there a better formula to determine how many "Y" are in a column?
Thanks