Forum Discussion
Solved
Simple sumif formula only adds one cell
My formula is simple and I've even tried retyping in into a new clean spreadsheet. If cell F7 is equal to Y, add cells A4:d4. Sounds simple to me, but it ignores cells B4, c4, and d4 and only ...
- I've suggested correct formula using the data from the attached file by you only,,, and both are working,,, check the sheet 1,,, Y is in cell F2 !!!
That works! I was on a tech support chat with Microsoft for about an hour and they agreed my simple formula should have worked and it didn't work on their end either. They too gave me a workaround of =IF(I6="Y",E6,SUM(E6:G6))
It's just weird that the first simple sumif didn't work.
In general if you use SUMIF() all ranges shall be of the same size. If sumRange consists of 4 cells, criteriaRange also shall have 4 cells.