Thread
:
Sum and multiply
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Art
external usenet poster
Posts: 587
Sum and multiply
Hello:
I have in row A for E.G. amounts, lets say:
A 3 6 4
B 2.00 3.00 2.50
Is there an easier way to calculate all together. The long way is
=(A1*B1)+(A2*B2)..., is there a shorter way to write this calculation?
Reply With Quote
Art
View Public Profile
Find all posts by Art