Take a number and divide it by 5 call it n and then your number is the sum of n-2 n-1 n n1 and n2. The approach for creating sequential row numbers in a table can be adapted to work with a named range like this. The general form of a consecutive even integers formula is given by.
Add those four numbers together with c and the sum of the five numbers is 5c.
Take a number and divide it by 5 call it n and then your number is the sum of n-2 n-1 n n1 and n2. If we convert the data to a proper Excel Table we can use a more robust formula. When adding up a list of numbers like this where the difference between each pair is the same we notice that if we take the sum of the first and last numbers in the list then the second number and the second-to-last number add up to the same su. One comes directly after the other as follows.