Forum Discussion
Dawn_Everidge
Sep 28, 2023Copper Contributor
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...
Dawn_Everidge
Oct 02, 2023Copper Contributor
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
HansVogelaar
Oct 02, 2023MVP
Glad you were able to solve it yourself!