Forum Discussion
Help with functions
I'm working on an inventory. I'm trying to get each row individually from D3 through D763 of number purchased in column D to first multiply by the next column E, from E3 to E763 of base cost for each...
The are two sensible ways of doing what you describe. Since the end of 2018 it can be done with a dynamic array formula
= LET(
cost, quantity * baseCost,
total, SUM(cost),
VSTACK(cost, total)
)Before that (2007 onward) one would have used an Excel Table for the calculation as well as to hold the source data
= [@quantity] * [@baseCost]and then inserted a Totals row for the Table. Before 2007 you would have had to use relative referencing.
