Anyone can help me?
I think use IF but i am not sure how it to do...
e.g the price is based on Col S (Option) and Col T (Company). If Col I is X, Col U will sum the price based on Col I if Col S and Col T x amount?
I think use IF but i am not sure how it to do...
e.g the price is based on Col S (Option) and Col T (Company). If Col I is X, Col U will sum the price based on Col I if Col S and Col T x amount?
| Book1.xlsx | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | |||
| 1 | Size | category | Type 1 | Type 2 | Type 3 | Type 4 | Type 5 | Type 6 | Type 7 | Type 8 | Delivery | Ad Hoc Job | Option | Company | Type 1 Cost | Type 2 Cost | Type 3 Cost | Type 4 Cost | Type 5 Cost | Type 6 Cost | Type 7 Cost | Type 8 Cost | Delivery Cost | Ad Hoc Job Cost | Total | ||
| 2 | 2B | Stationery | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | AP | $ 11.00 | $ 12.00 | $ 13.00 | $ 14.00 | $ 15.00 | $ 16.00 | $ 17.00 | $ 18.00 | $ 15.00 | $ 100.00 | $ 231.00 | ||
| 3 | 2B | Stationery | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | BB | $ 1.00 | $ 2.00 | $ 3.00 | $ 4.00 | $ 5.00 | $ 6.00 | $ 7.00 | $ 8.00 | $ 9.00 | $ 10.00 | $ 55.00 | ||
Data | |||||||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| AE2:AE3 | AE2 | =SUM(U2:AD2) |
| Book1.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | Option | Company | Type 1 Cost | Type 2 Cost | Type 3 Cost | Type 4 Cost | Type 5 Cost | Type 6 Cost | Type 7 Cost | Type 8 Cost | Delivery Cost | Ad Hoc Job Cost | ||
| 2 | 1 | AP | $ 11.00 | $ 12.00 | $ 13.00 | $ 14.00 | $ 15.00 | $ 16.00 | $ 17.00 | $ 18.00 | $ 15.00 | $ 100.00 | ||
| 3 | 2 | AP | $ 21.00 | $ 22.00 | $ 23.00 | $ 24.00 | $ 25.00 | $ 26.00 | $ 27.00 | $ 28.00 | $ 29.00 | $ 100.00 | ||
| 4 | 3 | AP | $ 31.00 | $ 32.00 | $ 33.00 | $ 34.00 | $ 35.00 | $ 36.00 | $ 37.00 | $ 38.00 | $ 39.00 | $ 100.00 | ||
| 5 | 4 | AP | $ 41.00 | $ 42.00 | $ 43.00 | $ 44.00 | $ 45.00 | $ 46.00 | $ 47.00 | $ 48.00 | $ 49.00 | $ 100.00 | ||
| 6 | 1 | BB | $ 1.00 | $ 2.00 | $ 3.00 | $ 4.00 | $ 5.00 | $ 6.00 | $ 7.00 | $ 8.00 | $ 9.00 | $ 10.00 | ||
| 7 | 2 | BB | $ 2.00 | $ 4.00 | $ 6.00 | $ 8.00 | $ 10.00 | $ 12.00 | $ 14.00 | $ 16.00 | $ 18.00 | $ 20.00 | ||
| 8 | 3 | BB | $ 3.00 | $ 6.00 | $ 9.00 | $ 12.00 | $ 15.00 | $ 18.00 | $ 21.00 | $ 24.00 | $ 27.00 | $ 30.00 | ||
| 9 | 4 | BB | $ 4.00 | $ 8.00 | $ 12.00 | $ 16.00 | $ 20.00 | $ 24.00 | $ 28.00 | $ 32.00 | $ 36.00 | $ 40.00 | ||
Option Price list | ||||||||||||||
