Only add values if right value is not "X"

D

dtov17

New member
Joined
Nov 24, 2016
Messages
2
Reaction score
0
Points
0
Hey!

In that totals box, what formula would i use to only add values in the amount column that aren't paid.
Based on the pic below, the total should therefore equal "200"


excelhelp.png
 
Like this:

=SUMIF($H$2:$H$6,"",$G$2:$G$6)

or this:


=SUMIF($H$2:$H$6,"<>Paid",$G$2:$G$6)
 
You must log in or register to reply here.
Back
Top