I have a question regarding an anomaly or something that is happening in Excel, but not always.
I have a spreadsheet with a column (K) of array formulas
=IF(INDEX(CCList,MATCH(0,COUNTIF($K$4:$K4,CCList),0))=0,"",INDEX(CCList,MATCH(0,COUNTIF($K$4:$K4,CCList),0)))
and in the column (L) to it's right, I have a column of SUMIF formulas
=IF($K4="","",SUMIF(CCRange,$K4,AMTRange))
So, sometimes when I click on cell L4 or any cell, the cells in column K move, so the SUMIF formulas move... but then other times, they do nothing.
Why is that happening and how can I stop it from occurring? Is there something wrong with my formulas to make this happen? I have no code designated for any change events. Note: I added a short video clip, and attached it in a zip file.
Thanks for your time and attention to this issue.
Jay
Bookmarks