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 ...
It sounds as if your yellow filled range is actually a single dynamic array, spilt from the top cell. Such arrays are valuable just because they prevent the accidental deletion of valid data. If you wish to delete a value, you need to reformulate the formula that gives rise to the array using
= IF(condition, SUMIFS(..., ..., ...), "").
Sorry for the late reply, I applied some condition it doesnt work brother, The thing is that I was working with 2019 in the office and i purchase 365, i was thinking it will help me, unfortunetealy other formula was working well with my style of working but in 365 the i dnt know why only the sumif has this issue.
Regards
Bijeesh