Jun 01 2022 03:28 AM
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.
Jun 01 2022 03:47 AM
=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.