Forum Discussion
Formulas not populating data in cell as required
what I meant is that for example
as you can see the data is zero when there is no issues with the formulas.
=COUNTIF(CR66:CR85,"A1A")
=COUNTIF(CR66:CR85,"A1B") and so on
but for these 3
=COUNTIF(CR66:CR85,"A1B")
=COUNTIF(CR66:CR85,"A3")
=COUNTIF(CR66:CR85,"A4")
the cell is not giving the number i want form this range of data above it is still showing zero.
In general formula works
But on second screenshot you have a lot of merged cells, perhaps here is an issue. Screenshot doesn't give details where the data is.
the second sreenshot is where the data is all other one but the 3 are working correctly and these 3 it just unknown as if it was the merged cells it would have failed for all not just these 3
Without the file it's hard to say why exactly the same formula works in one case and doesn't work in another
Another possible reason is circular reference, but that's just a guess.
