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.

​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.   Read More

​