I have a listing of salary figures for my organization. Several positions are
currently vacant, but the salary needed to fill the position is still listed.


How do I sum the range of figures to EXCLUDE the figures on rows where the A
column has VACANT typed in it?

Thank you for your help.