subtract amount in excel based on text value



I have a list of charge amounts. Some of these amounts have be paid and so they're marked YES, some of the charges have been waved and so they have been marked WAVED and some have not been paid so they're marked NO.


I need to put together a formula that adds up all the charges but subtracts those marked WAVED and YES.



1 Reply



 You can try above formulas.

yes no waved.JPG