krishnak
04-23-2008, 05:06 AM
Hi All,
I want to use the SUMIF function to sum up the product volumes in a large worksheet by the cost - let us say below 50, 51 to 100, 101 to 150, 150 and over. It is easy to write the conditional argument for the first and last cases - "<"&$B44 or ">149"&$B44, where B44 is the cell reference for the price.
For the condition of 51 to 100, I am now calculating the sum for all products costing less than 100, and then subtracting the sum of all the products costing less than 50.
Is there any way that I can achieve this in a single step - like ">50" &"And"&"<100"?
Thanks in advance for any suggestion.
- Krishna
I want to use the SUMIF function to sum up the product volumes in a large worksheet by the cost - let us say below 50, 51 to 100, 101 to 150, 150 and over. It is easy to write the conditional argument for the first and last cases - "<"&$B44 or ">149"&$B44, where B44 is the cell reference for the price.
For the condition of 51 to 100, I am now calculating the sum for all products costing less than 100, and then subtracting the sum of all the products costing less than 50.
Is there any way that I can achieve this in a single step - like ">50" &"And"&"<100"?
Thanks in advance for any suggestion.
- Krishna