Using Named Range to Refer to Cell Above
The last couple of times I've taught, I've received a question about how to deal with the following scenario: You have a table of data, say in A1:A10 In A11, you have the following formula:Â =sum(A1:A10) Someone highlights row A11,
