Multiplication Sums across cells?

by Viola F   Last Updated November 08, 2018 23:03 PM - source

Example image of what kind of thing i need

I know this isn't very professional but i'm very very new to google sheets and spreadsheets in general.

So if I know that Tier 4.3 leather is worth 6 points in the contest, someone brings me 739 of them along with 589 Tier 6.2 ore. Is there a way i could type 739 and 589 in the table on the right hand side and set up a formula in some way to allow the sheet to calculate how many points this person earned for that resource? Then i would just manually delete the values once i have a final number and start on the next person.

If anyone has any tips or favourite places to look where i can learn how to do things like this for myself that would also be amazing. I've taken to google but I find the jargon and terms a little daunting!

Tags : google-sheets

Answers 1

You're going to want to use the function =sumproduct()

In your case: =sumproduct(B3:E18,I3:L18)

Enter that in an empty cell to the side and your result will appear there when you enter values into the cells on the righthand table.

November 08, 2018 22:58 PM

Related Questions

Copying values between google sheets

Updated July 26, 2018 21:03 PM

Aggregate results by week and month for charts

Updated January 18, 2019 09:03 AM