vivienne3608
New Member
- Joined
- Sep 10, 2014
- Messages
- 17
Good afternoon,
I am hoping someone can help me with a problem I have. I have changed the actual details of the issue but the fundamentals are the same.
<o> </o>
I want to add the total cost of a particular item, in this example red balloons. Explanations of cells are as follows:
<o> </o>
Cells B1:O1 = Item
Cells B2:O2 = Quantity of items in an order
Cells B3:O8 = Number of orders for each item and quantity
Cells B11:C16 = Rate item charged at
Cells C19:D32 = Cost per quantity of item
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" span=18 width=64><TBODY>
</TBODY>
<o> </o>
Excel needs to look at the rate charged for the item (Red Balloon = Higher) then sum costs per order quantity. This should be:
<o> </o>
Red Balloon 1 20 x £20 = £400
Red Balloon 2 20 x £21 = £420
Red Balloon 3 10 x £22 = £440
Red Balloon 4 10 x £23 = £460
Red Balloon 5 20 x £24 = £480
Red Balloon 6 30 x £25 = £500
Red Balloon 7 22 x £26 = £520
<o> </o>
Total cost = £3,220.
<o> </o>
Any help is greatly appreciated.
<o> </o>
Thank you
<o> </o>
Vivienne
I am hoping someone can help me with a problem I have. I have changed the actual details of the issue but the fundamentals are the same.
<o> </o>
I want to add the total cost of a particular item, in this example red balloons. Explanations of cells are as follows:
<o> </o>
Cells B1:O1 = Item
Cells B2:O2 = Quantity of items in an order
Cells B3:O8 = Number of orders for each item and quantity
Cells B11:C16 = Rate item charged at
Cells C19:D32 = Cost per quantity of item
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
1 | Balloon | Balloon | Balloon | Balloon | Balloon | Balloon | Balloon | Pebble | Pebble | Pebble | Pebble | Pebble | Pebble | Pebble | Item | Balloon | ||
2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Colour | Red | ||
3 | Yellow | 20 | 40 | 30 | 100 | 160 | 80 | 260 | 10 | 10 | 20 | 20 | 40 | 20 | 20 | Cost | £3,220 | |
4 | Red | 20 | 20 | 10 | 10 | 20 | 30 | 22 | 60 | 140 | 70 | 60 | 50 | 10 | 10 | |||
5 | Blue | 20 | 20 | 10 | 20 | 30 | 20 | 85 | 230 | 170 | 170 | 250 | 310 | 200 | 200 | |||
6 | Green | 270 | 240 | 150 | 60 | 20 | 10 | 125 | 145 | 110 | 100 | 130 | 110 | 100 | 100 | |||
7 | Orange | 30 | 10 | 10 | 10 | 10 | 10 | 120 | 170 | 210 | 80 | 60 | 80 | 30 | 30 | |||
8 | Pink | 120 | 290 | 120 | 310 | 420 | 390 | 468 | 40 | 30 | 100 | 160 | 80 | 260 | 10 | |||
9 | ||||||||||||||||||
10 | Balloon | Pebble | ||||||||||||||||
11 | Yellow | Higher | Lower | |||||||||||||||
12 | Red | Higher | Lower | |||||||||||||||
13 | Blue | Lower | Higher | |||||||||||||||
14 | Green | Lower | Higher | |||||||||||||||
15 | Orange | Lower | Higher | |||||||||||||||
16 | Pink | Higher | Lower | |||||||||||||||
17 | ||||||||||||||||||
18 | Lower | Higher | ||||||||||||||||
19 | Balloon | 1 | £16 | £20 | ||||||||||||||
20 | Balloon | 2 | £17 | £21 | ||||||||||||||
21 | Balloon | 3 | £18 | £22 | ||||||||||||||
22 | Balloon | 4 | £19 | £23 | ||||||||||||||
23 | Balloon | 5 | £20 | £24 | ||||||||||||||
24 | Balloon | 6 | £21 | £25 | ||||||||||||||
25 | Balloon | 7 | £22 | £26 | ||||||||||||||
26 | Pebble | 1 | £23 | £27 | ||||||||||||||
27 | Pebble | 2 | £24 | £28 | ||||||||||||||
28 | Pebble | 3 | £25 | £29 | ||||||||||||||
29 | Pebble | 4 | £26 | £30 | ||||||||||||||
30 | Pebble | 5 | £27 | £31 | ||||||||||||||
31 | Pebble | 6 | £28 | £32 | ||||||||||||||
32 | Pebble | 7 | £29 | £33 |
<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" span=18 width=64><TBODY>
</TBODY>
<o> </o>
Excel needs to look at the rate charged for the item (Red Balloon = Higher) then sum costs per order quantity. This should be:
<o> </o>
Red Balloon 1 20 x £20 = £400
Red Balloon 2 20 x £21 = £420
Red Balloon 3 10 x £22 = £440
Red Balloon 4 10 x £23 = £460
Red Balloon 5 20 x £24 = £480
Red Balloon 6 30 x £25 = £500
Red Balloon 7 22 x £26 = £520
<o> </o>
Total cost = £3,220.
<o> </o>
Any help is greatly appreciated.
<o> </o>
Thank you
<o> </o>
Vivienne