Forum Discussion
Excel 365 after applying sumif formula cant delete formula in specified cell
Dear juliano,
Nope, it was not nested, the online MS office agents where checking, they revert me to here. Please find the screen shot
The formula you show is greyed out because it is not actually present in the cell you are trying to edit. The formula is in the top cell of the range and simply uses other cells to display the calculation result provided they are blank. The whole column reference means that the formula performs over a million calculations and the used range covers entire columns.
To modify a term of a dynamic array, you need to build the criterion into the formula. If you choose to omit values, it is usually a good idea to document the change to indicate the reason for the anomaly.
- Thanking you so much for the file, I was trying to add some formula together with the existing formula it is not working, also trying to add some text or numbers in the column it show spill.
Let's start with my opinion that 365 is a far better product than any other traditional spreadsheet software that I know of. The thing that is wrong is the working practices that 2016 allowed you to adopt and 365 prevents. I would suggest that such working practices whereby 2+2 normally equals 4 but you may change it 5 here or there, or possibly delete it altogether is a superb way of generating errors that are difficult to detect within a large dataset. They contribute to the fact that only about 1 in 10 spreadsheets is reasonably error free.
If you wish to override specific calculations then this is best achieved by introducing a new data column which provides a basis for the alternative calculation. A classic example is a forecast which only shows if no actuals have been provided.
Sorry for being rude, but as I see it, it is the software that should be applying for a new user!
[don't take that too seriously but you might give it a little consideration before moving on].
