HappyChappy
Active Member
- Joined
- Jan 26, 2013
- Messages
- 378
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
hi,
I have two columns of data for amount of vehicles and cost per unit so A1 to A6 would be amounts of vehicle held and B1 to B6 would be Cost of vehicle held
What i want is to show in b1 to b6 the individual price of each unit but in the total b7 to look at the individual price of each vehicle held then X it by the A column of vehicles held
So for example i have a3 with 4 and b3 with 70,000 so i need to X these together to get the total and work over the whole range so b7 only shows the overall price of vehicles held
So basicly it needs to look at b1 to b6 then then X each cell by the corresponding a1 to A6 and give a total in B7
I don't want to use macro's to achieve this
Hope I have explained this correctly thanks in advance for any help.
I have two columns of data for amount of vehicles and cost per unit so A1 to A6 would be amounts of vehicle held and B1 to B6 would be Cost of vehicle held
What i want is to show in b1 to b6 the individual price of each unit but in the total b7 to look at the individual price of each vehicle held then X it by the A column of vehicles held
So for example i have a3 with 4 and b3 with 70,000 so i need to X these together to get the total and work over the whole range so b7 only shows the overall price of vehicles held
So basicly it needs to look at b1 to b6 then then X each cell by the corresponding a1 to A6 and give a total in B7
I don't want to use macro's to achieve this
Hope I have explained this correctly thanks in advance for any help.