I need a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula that will tell me which amounts in a list will add up to a specific amount.
 
Hi
you may give a little bit more information:
1. Is it sufficient to sum up starting in row 1 until a specific amount
is reached (or the sum is larger than you specified value). If yes try
the following:
- column A contains your values
- C1 the amount to rech
- enter the following in B2:
=IF(SUM($A$1:A1)<$C$2,"X","")
and copy down. This places an 'X' in all rows which are needed to sum
up to the amount in C1 (also enter manually an 'X' in B1 as the first
row is always required)

2. Or do you need an exact match. That is you need a combination of
'random' rows which match excatly the specified amount. If yes: quite
difficult, VBA required
 
Back
Top