Formula not calculating correctly

Copper Contributor

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

@ReeseXposed 

Can you share a screenshot or sample workbook of your formula? See below how a SUMIF function would work:

adversi_0-1606689540500.png

 

@ReeseXposed 

 

If possible please share the file with us,,, help us to fix the issue.

@ReeseXposed 

Perhaps some values are pasted as texts, please check if all values you sum are numbers.