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 make sense, but I have data in the four cells to the right of the criteria cell which is all numbers. Since there will be no "Y" in those, it may work. I'll check that out.
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 !!!
- I like it. And - Thanks so much.
- Glad to help you,,, keep asking ☺