Forum Discussion
subtract amount in excel based on text value
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 s...
=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.