I'm running into a new problem with SUMIF. A workbook illustrating the prob is attached.
What I want is a single cell (not a range of cells) to give me the sum of values in M30:M231 if the corresponding row in column C ="L"
So if C31="L" then we include M31 in the addition.
The formula either produces a 0 as a result, or a !Spill error, depending on whether the criteria is written as C30="L" or C30:C231="L".
I've also tried SUMIFS and the formula still wants to spill into the rows below.
Not sure what I'm doing wrong.
Any advice? thanks!
Bookmarks