Adding up numbers from columns.

L

LarryRI

How can I sum up multiple columns while not letting each cell
"associated values" sum to a number greater than one specified.

For example,

if I have sets of colums:

14 3
12 2
11 2
11 1
10 1

and

20 5
19 4
18 3
17 2

and

25 6
22 4
20 3
18 2

I want to know what 3 combination of numbers in the left 3 colums giv
me the highest value...WITHOUT letting the correspoding numbers in th
right hand column be greater than, say 10.

Thanks,

Larr
 

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

Top