View Single Post
  #1   Report Post  
Ken
 
Posts: n/a
Default calculate which cells in column A will give me the total of column

i have the following spread sheet that reeds like this

Column A B C D

1
2
3
4
5
6
8 6 7
what would the formula be that would indicate which cells (in column A)to
use to achive the total at the bottom of each column, provided that each
number is only used once. this is a basic version of the spreadsheet that i
am trying to calculate.
Regards
Ken