Hello all.

Let’s say I have 10 cells with different numbers in them- cells A1 to A10.

A11 contains the formula =SUM(A1:A10) and thus displays the total of cells A1 to A10.

What methods could I use to exclude cells A5 and A6 from this total (other than using the formula =A1+A2+A3+A4+A7+A8+A9+A10 in cell A11, of course).