J
jaxpunx
I am trying to figure out a way to sum a range if it is less than th
value in another range. Basically, I have a column of data in colum
A. In column B, I have a column of numbers that are break points.
Let's say that column A is the numbers 1-100. Column B has 10, 20, 30
40, etc up to 100. I want to write a sumif formula that will add u
the numbers that are greater than 10, the numbers that are greater tha
20, etc. I know that I can put ">10" as the criteria and make it work
I really need to be able to use the range that contains the #10 as th
criteria, as 1) I want to be able to copy it around without manuall
changing the criteria field in the formula, and 2) I want to be able t
have the criteria number change. If I decide to use 15, 25, 35, 45
etc as the breakpoints, I want to be able to just enter those number
into column B and have the sumif formulas in column C take care of th
conversion.
Please HELP!!
Thanks in advance to anyone that knows the answer to this question!!!!
value in another range. Basically, I have a column of data in colum
A. In column B, I have a column of numbers that are break points.
Let's say that column A is the numbers 1-100. Column B has 10, 20, 30
40, etc up to 100. I want to write a sumif formula that will add u
the numbers that are greater than 10, the numbers that are greater tha
20, etc. I know that I can put ">10" as the criteria and make it work
I really need to be able to use the range that contains the #10 as th
criteria, as 1) I want to be able to copy it around without manuall
changing the criteria field in the formula, and 2) I want to be able t
have the criteria number change. If I decide to use 15, 25, 35, 45
etc as the breakpoints, I want to be able to just enter those number
into column B and have the sumif formulas in column C take care of th
conversion.
Please HELP!!
Thanks in advance to anyone that knows the answer to this question!!!!