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

SergeiBaklan's avatar
SergeiBaklan
MVP
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