I am running a sumifs function which checks 3 criterias, and must written sum in a single cell. But it automatically returns two more values as 0s in adjacent 2 cells which results in a SPILL! error when I copy the formula and change references respectively.
as per the image I need a sum value based on matching criterias for columns E,F, and G. However, when I am replacing the values for next column, it returns a SPILL. What can be done? I can do it by leaving 2 columns but I know there must be a way out without doing that.