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...
Try this formula:
=LET(
product, D3:D763 * E3:E763,
total, SUM(product),
VSTACK(product, total)
)
Thank you! I will try these!!