I'm trying to apply multipliers to rows within a column total, having issues.. I've tried multiple attempts using ARRAYFORMULA, MULTIPLY, SUM, and combinations of these, with no luck..
Search attempts included (via both Google and Bing) "Google Sheets - Multiply Rows/Columns By Given Cell" in a variety of wordings; to which the most relevant result has always been "How to Multiply Numbers in Google Sheets"
I have a table that looks like this:
Totals = = 5 = 1 ============================================== Multiplier = Row Label = Column 1 = Column 2 ============================================== 0 = = 1 0 1 = = 1 1 2 = = 2 0
As you can see in the example, I've applied the multipliers to demonstrate what I'm looking for.
What I'm looking for is for the "Totals" Row to reflect the "Multiplier" associated with the given column and row..
If possible, I'm trying to do this without applying any custom functions..