Nov 29 2020 02:21 PM
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?
Nov 29 2020 02:39 PM
Can you share a screenshot or sample workbook of your formula? See below how a SUMIF function would work:
Nov 29 2020 09:54 PM
Nov 30 2020 09:28 AM
Perhaps some values are pasted as texts, please check if all values you sum are numbers.