Find what values equal a total

  • Thread starter Thread starter vtpaul
  • Start date Start date
V

vtpaul

Say I have a list of various values that add up to 100. I also have
two subtotals, say 35 and 65. Is there a formula or a way to easily
find which of the values would add up 35 and which would add to 65?
Thanks.
 
Insert this formula in column B, and copy down:
=INDEX($A$1:$A$20,MATCH(100,(A1+$A$1:$A$20),0))

The formula will return the first matching value, that adds up to 100.

HTH
Ola Sandström


Note:
Confirm the formula by holding down Ctrl and Shift, then hit Enter
(since it's an Array formula)
Array formulas:
http://www.personal-computer-tutor.com/arrayformulas.htm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal of Hidden Values over a certain amount of days 1
Various data in a row for dulicate fields in column 3
I need to OR some functional IF(AND sets 2
Pivot Table Subtotals do not add properly 5
Finding the value of a cell for another cell to equal a certain number 7
Add cells in a column where other cells equal a value 3
keeping YTD numbers 3
display total in stacked column chart 3

Back
Top