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.
|