Forum Discussion

TimW1725's avatar
TimW1725
Copper Contributor
Sep 13, 2024

Addition & Multiplication in one cell?

Hi, I'm building a formula that tracks revenue as per piece counts.  The table shown would need to calculate column B, while :heavy_multiplication_x:  column C10   Is there a way to do this apart ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 13, 2024

    TimW1725 

    As variant

    =SUM(TOCOL(B4:B9*C4:C9,3) )

    if you are on Excel 365

TimW1725's avatar
TimW1725
Copper Contributor
Sep 13, 2024
Thank you Sergel That worked!😊 I was up until 1;00am trying to resolve this!! Thank you.

Resources