COUNT Function Not Counting All Numbers

I need to count numeric cells in a column where the result in each cell is the result of a nested IF condition. I didn't see any other thread that addressed this situation.

Is this even possible without some VBA magic? Unfortunately, I know nothing of VBA, so I don't know that this is even an option. I have tried COUNT and COUNTIF with inaccurate results. I have also made sure that the cells are appropriately formatted as a number.

Thanks in advance.

Re: Count where individual cell results product of formula

It is not counting any cell where the result in that cell was the result of the nested IF condition formula.

Re: Count where individual cell results product of formula

Quote from daddylonglegs

Possibly your nested IF formula returns text formatted numbers. If they are enclosed in quotes then they'll be treated as text.

Solution: remove quotes

Note also that values returned by LEFT, RIGHT and MID formulas are always text and may need to be "co-erced" to numbers

If that isn't it.....then post your nested IF formula

Display More

daddylonglegs,

That was it! It didn't even cross my mind that because the numeric result in my formula was wrapped in quotes that Excel would treat it as text. Learn somethin' new everyday.

Thanks for pointing me in the right direction and have a great day!