I want to find a formula to sum up a column equal or over a specific value.
For example:
I have a list of products with quantities and prices (Row 8 to Row 40)
For Product A, I want to sum up enough Quantities in the list that would equal 30 or 1 item more than 30 quantities.
- Product A criteria is 30qty. The result for I want would be 30 qty (sumB9:B12), $65 (sumC9:C12)
- Product B criteria is 13qty. The result for I want would be 17qty and $22)
I was thinking using a sumif formula..
Can someone help?
Thanks
For example:
I have a list of products with quantities and prices (Row 8 to Row 40)
For Product A, I want to sum up enough Quantities in the list that would equal 30 or 1 item more than 30 quantities.
- Product A criteria is 30qty. The result for I want would be 30 qty (sumB9:B12), $65 (sumC9:C12)
- Product B criteria is 13qty. The result for I want would be 17qty and $22)
I was thinking using a sumif formula..
Can someone help?
Thanks
Attachments
Last edited: