Would like to subtract an amount from a certain value I enter at the time of
typing the formula if the item is from certain category

For example:

category amount total
video $17 =sumif(category = video, subtract amount
from a given value)


Any suggestions would be appreciated.

Best Regards,
Eleanor


--
Estandardtime Realty