I'd use SUMIF

Basic syntax is SUMIF(range, criteria, [sum_range])



In your case the formula would look something like this:


=SUMIF(C2:C4,"<>Private",B2:B4)