Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
2 | Amount | AmountInCarton | ||||
3 | 600 | 12 | ||||
4 | 456 | 12 | ||||
5 | 54743 | 12 | ||||
6 | 2346 | 12 | ||||
7 | 235623 | 24 | ||||
8 | 3257 | 6 | ||||
9 | 4574 | 24 | ||||
10 | 34 | 24 | ||||
11 | 777 | 4 | ||||
12 | 457 | 24 | ||||
13 | 45724 | 12 | ||||
14 | 27627 | 12 | ||||
15 | 755 | 6 | ||||
16 | 573 | 12 | ||||
17 | 325 | 48 | ||||
Sheet1 |
Normally there are upto 18000 rows but,
Using the above example where ColA is units and ColB is how many units in a carton, without having the formula (ColA/ColB) in ColC and then adding it up at the bottom.
I wish to have the total amount of cartons in one formula is this possible?
Brett
This message was edited by brettvba on 2002-10-24 20:13