View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Can excel tell me what numbers in a given column sum to X?

I am looking to find a way to get Excel to tell me which cells in a given
column sum to a given X.

For example, the numbers 1, 5, 10, 15, 16, & 20 are in a column. I ask,
which of these numbers sums to 36? I am looking for something that responds
with e1+f1; a1+a2+a3+f1; a1+d1+f1, etc.