Addition & Multiplication in one cell?

[TimW1725]

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 from a static SUM B4:B9*C10?  As some routes will not use all service fields as shown in the attached photo.

Thank you.

 

[#2 · Accepted solution]

@TimW1725 

As variant

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

if you are on Excel 365

[#3]

Thank you Sergel That worked!😊 I was up until 1;00am trying to resolve this!! Thank you.

[#4]

@TimW1725 , you are welcome