Sumif Formula
 

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

Sumif Formula
 

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Eleanor M" wrote in message
...
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

Sumif Formula
 

Thanks.

Best of luck in your endeavors.
Eleanor
--
Estandardtime Realty


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Eleanor M" wrote in message
...
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