I have a spreadsheet that has a set number of ranges for each row. It looks
something like this:
col1 col2
1-100 $$$$
101-200 $$$$
201-300 $$$$

In another part of the spreadsheet I have a range of data containing dollar
amounts. The data looks something like this:
col5
99
127
299

What I want to do is to read through the column in this data and place the
amounts in the correct range. So for this example the value in the first
cell in col5 is 99, so it would go in the column with the range of 1 - 100.
It would read through the value ranges until it found a valid range.

I hope I am explaining this correctly. Any help would be great. Thanks

will there only be one number for each range as your example shows. If not,
why not just sort them, then copy and paste?

If not, where do multiple values go (add them?, list to the right?)

If you are going to add them, then you would be better off using sumif to
get a total. If there will only be one per range, you could also use sumif.


--
Regards,
Tom Ogilvy


"tedd13" wrote:

I have a spreadsheet that has a set number of ranges for each row. It looks
something like this:
col1 col2
1-100 $$$$
101-200 $$$$
201-300 $$$$

In another part of the spreadsheet I have a range of data containing dollar
amounts. The data looks something like this:
col5
99
127
299

What I want to do is to read through the column in this data and place the
amounts in the correct range. So for this example the value in the first
cell in col5 is 99, so it would go in the column with the range of 1 - 100.
It would read through the value ranges until it found a valid range.

I hope I am explaining this correctly. Any help would be great. Thanks

Tom,

Yes there are multiple values. I tried the sumif and it kind of worked.
The problem I found with it is that it looks like you can only use one
criteria to check against. For example:
SUMIF(C1:C17,"<=200",B1:B17).
This will give me the range from 101 - 200 but also the range from 1 - 100.
Is there a way to put somekind of 'between' logic in a statement like that?

Thanks

"Tom Ogilvy" wrote:

will there only be one number for each range as your example shows. If not,
why not just sort them, then copy and paste?

If not, where do multiple values go (add them?, list to the right?)

If you are going to add them, then you would be better off using sumif to
get a total. If there will only be one per range, you could also use sumif.


--
Regards,
Tom Ogilvy


"tedd13" wrote:

I have a spreadsheet that has a set number of ranges for each row. It looks
something like this:
col1 col2
1-100 $$$$
101-200 $$$$
201-300 $$$$

In another part of the spreadsheet I have a range of data containing dollar
amounts. The data looks something like this:
col5
99
127
299

What I want to do is to read through the column in this data and place the
amounts in the correct range. So for this example the value in the first
cell in col5 is 99, so it would go in the column with the range of 1 - 100.
It would read through the value ranges until it found a valid range.

I hope I am explaining this correctly. Any help would be great. Thanks