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 ...
Hi Peter,
Yesterday while I was in the office i was doing the same formula with 2016 Excel, For the reconciliation purpose, I used to del specified cell. The same I was doing after purchasing 365 it is not happening. As you said if to prevent accidental deletion of valid date, how is it possible to del the specific cell formula With Vlookup and other formulas?. I will try your solution in 365
Yesterday while I was in the office i was doing the same formula with 2016 Excel, For the reconciliation purpose, I used to del specified cell. The same I was doing after purchasing 365 it is not happening. As you said if to prevent accidental deletion of valid date, how is it possible to del the specific cell formula With Vlookup and other formulas?. I will try your solution in 365
Since the second argument of your SUMIF formula is the entire column A. Excel has spilled it to the entire column D. You can only edit and delete if you select the entire column D, and it will affect the entire column.
- Dear Hans,
What is the issue cant be solved by them what is the next step, Can I ask for a refund. I would like to get an advisory from a experienced mentor like youI cannot help you with a refund, sorry.
- I understand, the question is, what if we really need to del one specific line or adding additional formula?. I was working with 2019 and other versions why not with 365.