Hi all,
Im new to exel & looking to do up a iventory spreedsheet, where I can have a cost of an item in a column(a), next column(b) how many items & then a total in the next column(c).
I have worked out how to do the multiply column 'a' & 'b' with total in column 'c' per line.
Is there a way I can setup so I can multiply column 'a1' all the way to column 'a100' with column 'b1' to 'b100' to give totals in cloumn 'c1' to 'c100' or do I have to do each line individually.
I hope my question makes sense.
Cheers, Paul
if you have the data in columns a and b then just make sure the formula in c1 is =A1*B1 then select the cell C1 and drag the little black box on the right hand lower corner of the selected cell down to row 100.
If you can't figure out how a formula works, try stepping through it using "Evaluate Formula" in the Formula Auditing menu item in the tools menu!
If you want to see where your code went wrong, try stepping through it by clicking in the code and pressing F8 and watch as the magic happens!
If you are happy with any of the results, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post.
Thankyou Everstrivin.
That what I was after.
Cheers, Paul
Please take a few minutes to read the forum rules about thread titles before posting again.
Thanks.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks