Hello.
I am new to the community and this is my first post/request
I am trying to calculate weighted average and here is my sample data:
A B C
Part # QTY Cost Ea
1. 0304-C-24 850.00 $1.00
2. 0306-04 15,000.00 $0.0213
3. 0306-04 9,836.00 $0.0813
4. 0306-06 6,600.00 $0.0111
5. 0306-06 9,900.00 $0.0111
6. 0306-06 5,500.00 $0.3331
7. 0306-06 25,000.00 $0.1111
8. 0306-06 10,500.00 $0.2255
9. 0306-08 15,000.00 $0.0111
10. 0306-08 10,000.00 $0.1010
11. 0306-08 4,550.00 $0.1010
12. 0306-08 5,450.00 $0.0101
13. 0306-08 3,000.00 $0.1010
Any suggestions as to how to calculate weighted average for lines A2-A3 and than for A4-A6, etc? i have over 3,000 lines with different part numbers and cost
Thank you very much!
Dennis
I am new to the community and this is my first post/request
I am trying to calculate weighted average and here is my sample data:
A B C
Part # QTY Cost Ea
1. 0304-C-24 850.00 $1.00
2. 0306-04 15,000.00 $0.0213
3. 0306-04 9,836.00 $0.0813
4. 0306-06 6,600.00 $0.0111
5. 0306-06 9,900.00 $0.0111
6. 0306-06 5,500.00 $0.3331
7. 0306-06 25,000.00 $0.1111
8. 0306-06 10,500.00 $0.2255
9. 0306-08 15,000.00 $0.0111
10. 0306-08 10,000.00 $0.1010
11. 0306-08 4,550.00 $0.1010
12. 0306-08 5,450.00 $0.0101
13. 0306-08 3,000.00 $0.1010
Any suggestions as to how to calculate weighted average for lines A2-A3 and than for A4-A6, etc? i have over 3,000 lines with different part numbers and cost
Thank you very much!
Dennis