Forum Discussion
Excel 365 after applying sumif formula cant delete formula in specified cell
I have applied sumif formula and drag down, the formula went all and got the result as well. While deleting formula in specified cell or applying other formulas together with sumif in that specified ...
Does the formula starts with "{" and ends with "}" ?
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.
