Sumif Formula

[Guest]

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

 

[Bob Phillips]

=IF(A2="video",100-B2,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Thanks.

Best of luck in your endeavors.
Eleanor