Forum Discussion

RachelSchermann46's avatar
RachelSchermann46
Copper Contributor
Feb 29, 2024

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...
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor

RachelSchermann46 

Try this formula:

=LET(
    product, D3:D763 * E3:E763,
    total, SUM(product),
    VSTACK(product, total)
)
RachelSchermann46's avatar
RachelSchermann46
Copper Contributor
Mar 01, 2024
Hi, thanks. I'm sorry, I'm very basic knowledge of Excel. I get confused on what numbers, go where, what columns and rows if any I highlight for the equation reference boxes and where I want the answers to go. I tried this formula =LET(PRODUCT,D3:D5*E3:E5,TOTAL,SUM(F3),VSTACK(F5,TOTAL)) in a small sample of D3 through F5 sample and it didn't work. I also tried pasting in what you wrote verbatim and it also didn't work. Error messages. If able to, would you please see what mistakes were made and help me correct as needed?

thank you