Anomandaris
03-30-2009, 01:50 AM
Hi guys,
I need to show the weighted average at the end of every section, i'm not sure how to get that in a macro, as the quantity varies (number of cells with relevant values, you'll see what i mean on the file).
On the sheet 'SCORE' you can see the raw data
On the Sheet1 you see a table, i dont need any macro for the table, i just want something so i can plug in the weighted average in Column F. In COlumn D you see the Price/unit, in Column E the quantity/lots @ that price....so at the end of each section where it says 'Lots@Avg.Price' I need to have the weighted avg calculated on the same row in Column F.....right now you will see '0's where i need the average........
Any idea how i can do this? Any help would be fantastic
Thanks a lot
I need to show the weighted average at the end of every section, i'm not sure how to get that in a macro, as the quantity varies (number of cells with relevant values, you'll see what i mean on the file).
On the sheet 'SCORE' you can see the raw data
On the Sheet1 you see a table, i dont need any macro for the table, i just want something so i can plug in the weighted average in Column F. In COlumn D you see the Price/unit, in Column E the quantity/lots @ that price....so at the end of each section where it says 'Lots@Avg.Price' I need to have the weighted avg calculated on the same row in Column F.....right now you will see '0's where i need the average........
Any idea how i can do this? Any help would be fantastic
Thanks a lot