A B C D
1 Name Member Status Sales
2 ALL £0.00
3 Beccy N/A N/A £0.00
4 Bethan N/A N/A £0.00
5 Chris N/A N/A £0.00
6 Danni N/A N/A £0.00
7

can't post the spreadsheet so here is a summary table - rows 1-6 are the summary section with the database starting below it at row 7.

"Member" & "status" will be different for each sale so they are not summed, but the sales column is - it uses a simple sumif formula to sum the sales below in the data base - so the formula in cell D5 would be =SUMIF(A7:A100,A5,D7:D100).

So rows 7:100 are the data fields and don't contain formula.

When I add data to cell A7 and press return excel autofills cell D6 down cell D7. Which then causes a circular error as the formula is within its own sumif range.

The cells are not linked.

I thought initially that there was a bug in the autocomplete option (as the name would autocomplete as I typed it and then the formula a few columns over would autofill by itself, but I've tried names not on the list and turning off autocomplete all together and cell D7 still autofills.

The low tech solution appears to be to leave a line between the summary and the datafields (so leave row 7 blank). This was my immediate solution and it works, but I want to understand why this suddenly started happening - is it another excel bug?

I've tried