Maybe this:

=SUMIF(A1:A100,"<Vacant",B1:B100)

--
Biff
Microsoft Excel MVP


"ibhavn" wrote in message
...
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.