subtract amount in excel based on text value

Copper Contributor

Hi

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

@cheeseontoast101 

=SUMPRODUCT(($B$2:$B$19<>"yes")*($B$2:$B$19<>"waved")*$A$2:$A$19)
=SUMIF($B$2:$B$19,"no",$A$2:$A$19)

 You can try above formulas.

yes no waved.JPG