Hi Gary's Master

Yes, it works.

Thanks a lot.

You are great.

I still need to figure out John's approach too.

Best regards,

--
sarans


"Gary''s Student" wrote:

Hi sarans:

With only 5 numbers, John's approach can be applied withou solver:

1. enter you values into A1 thru E1 and copy down to row 32.
2. enter the following table in F1 thru J32:
0 0 0 0 0
0 0 0 0 1
0 0 0 1 0
0 0 0 1 1
0 0 1 0 0
0 0 1 0 1
0 0 1 1 0
0 0 1 1 1
0 1 0 0 0
0 1 0 0 1
0 1 0 1 0
0 1 0 1 1
0 1 1 0 0
0 1 1 0 1
0 1 1 1 0
0 1 1 1 1
1 0 0 0 0
1 0 0 0 1
1 0 0 1 0
1 0 0 1 1
1 0 1 0 0
1 0 1 0 1
1 0 1 1 0
1 0 1 1 1
1 1 0 0 0
1 1 0 0 1
1 1 0 1 0
1 1 0 1 1
1 1 1 0 0
1 1 1 0 1
1 1 1 1 0
1 1 1 1 1

3. in K1 enter:
=SUMPRODUCT(A1:E1,F1:J1) and copy down.
Just pick the correct value out of column K
--
Gary's Student


"sarans" wrote:

how to identify a few cells in a list(A1) that sums a equal total in another
cell(B1)

i.e:

A1
---
1,245.55
34,543.68*
8,955.67*
43,873.93
11,282.08*

B1
---
54,781.43

thanks in advance.
--

sarans