Forum Discussion
Formula not calculating correctly
I entered a "sumif" formula and it is not adding up all the cells in the range. The formula is entered correctly. I think the problem is that I have copied older versions of excel and pasted them into this newer version. I have gotten alerts when I do this. So, now it is not recognizing some of the cells within a given range. How do I correct this?
3 Replies
Perhaps some values are pasted as texts, please check if all values you sum are numbers.
Can you share a screenshot or sample workbook of your formula? See below how a SUMIF function would work:
