Formula

Ash2024

If I want the total profit column to increase to reflect when the items sold column increases, How would I write the formula. I am very new to this thank you.

AravindGP

Hi @Ash2024

I am not sure if you intend to use just one row and keep changing the items sold value. If you're, your Total Profit Column could be a simple formula of =[Items Sold column]@row x [Total Cost column].

johngraham78

@Ash2024

Can you provide a screen shot or more context?

Ash2024

I would like to write a formula so that if the number of items sold goes up it would automatically reflect accurately in the total profit column.

Zachary Hall

You would enter this in the Total Item Profit Column:

• =[My royalty/ profit]@row * [Total number item sold]@row

Hope this helps!