Profit formula

JulieBerryman

Sorry for the basic question. I need a row that calculates profit. I have a row titled COGS and a row titled Sold Price and a row titled Profit/Loss. What and how do I add a formula to the Profit/loss row that would calculate that for me? I am SO GRATEFUL for any help!

I tried this formula

=Sold Price@row - COGS@row

and this is the error code that returned.

Thanks!

Julie

dojones

Use [Sold Price]@row - COGS@row.

If there is a space in title, it must be bracketed.

dojones

Use [Sold Price]@row - COGS@row.

If there is a space in title, it must be bracketed.

JulieBerryman

@dojones

WORKED! Thank you so much!!