View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nick Savage Nick Savage is offline
external usenet poster
 
Posts: 3
Default Variable reference to add cells

I want to use a variable to add a number of cell values together:

in the example below cell 'e3' needs to be the sum of cells a1:a2 less the
sum of cells a4:e5 but I need to use the value of cell 'a5' to 'go back' 4
columns so that I can vary the number of columns to count back by changing
the value of a5.

a b c d e
1 10

2 20

3

4 2 2 4 2 2

5 4

Thanks