Forum Discussion
Countifs function fails
I've had a spreadsheet that's been working for months and I woke up this morning to all of my countifs that use reference one column on the spreadsheet failing with the #VALUE!. Other countifs are s...
Thanks so much for you message. I was able to locate the problem. I had added a line to the bottom of the document and messed up the calculation probably by only adding cells and not an entire row so the formula was seeing the inconsistency between number of lines in the columns. So user error as expected! HansVogelaar
Glad you were able to solve it yourself!