Countifs formula not counting data points
Hi Experts Using Excel 2010
I have the following countifs formula which is not counting data keeps on returning zero all the time
=COUNTIFS(K6:K881,"BCP",$F
cannot see error
I have the following countifs formula which is not counting data keeps on returning zero all the time
=COUNTIFS(K6:K881,"BCP",$F
cannot see error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you are welcome.
Changing the reference to column K to absolute will make no difference to a single formula; if that cell is copied to another cell without the absolute reference then it will change whereas having an absolute reference will keep it the same.
I believe the issue is the use of the >= and < operators. The formula is currently looking for items where column FL is equal to text ">=90000" and is equal to "<100000".
The correct syntax should be:
=COUNTIFS($K$6:$K$881,"BCP
I believe the issue is the use of the >= and < operators. The formula is currently looking for items where column FL is equal to text ">=90000" and is equal to "<100000".
The correct syntax should be:
=COUNTIFS($K$6:$K$881,"BCP
Ignore that, just looked at Flora's sample and it works with the original syntax of the operators. I always just do it with the operators in quotes so that you can then refer to a cell rather than a fixed value.
However, the formula as quoted in the question works without the absolute reference on column K. Therefore, I suggest the issue is in the data and the count is not finding data that match the criteria.
Thanks
Rob
However, the formula as quoted in the question works without the absolute reference on column K. Therefore, I suggest the issue is in the data and the count is not finding data that match the criteria.
Thanks
Rob
ASKER