Here's how it is setup....

Column B C D E F G (The same for J K L M N)
S M L XL 2XL 3XL

I would then place a quantity in whichever size(s) needs ordered. However,
the price for F&G and M&N differ from the rest. So I would like the formula
to recognize the quantity in whichever column, grab the correct price and
calculate in column H, as well as column O. (probably 2 different formulas,
for 2 different cells, but same concept)

Is this even possible? Or am I asking for too much?

TYVM

"RidgeView" wrote:

I hope I am understanding you properly.
In this example, the prices are above the quantities (they could be anywhere).
Using your cell examples:
B C D E F G H
Row 2 17.50 17.50 17.50 17.50 19.50 19.50
Row 3 2 35.00
In H3 the following formula:
=IF(B30,B3*B2,IF(C30,C3*C2,IF(D30,D3*D2,IF(E30 ,E3*E2,IF(F30,F3*F2,IF(G30,G3*G2,""))))))

Hope this is what you need.......
Regards...

"adburnheimer" wrote:

I hope someone can help me, and I hope I can explain this fully.

I have a worksheet to tally sizes and prices. Larger sizes have a higher
price. Currently, it looks like this:

B3:E3 are all the same price, which is tallied in H3 (or 4, 5 ,6 and so on)
F3:G3 are the same, but different than the others.

I would like H3 to end with the quantity from B3:G3, at the correct price.

Example--
B3 is a small, priced at 17.50. Whereas F3 is a 2XL priced at 19.50.
If B3 has a quantity of 2, I would like H3 to calculate $35.00. Or if the
quantity is in another row/column, then it will calculate the proper price,
based on the size. If there is a quantity of 2 in F3, then H3 would return
39.00.

I have this in 2 different sections in the worksheet. I also have a total
row, and total column at the bottom of the worksheet. Ideally, I want to be
able to total the amount of small, med, lrg, etc, as well as total price, etc.

Thank you very much, in advance for any help you can give. I have been
working on this formula for days. I have the rest of the worksheet done, but
this.

Angie