You're welcome!

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

< means "is not equal to"

So in plain English, sum the cells in column B where the cells in column A
is not equal to vacant.

--
Biff
Microsoft Excel MVP


"ibhavn" wrote in message
...
Wonderful! That worked, now if I just understood why it worked. Thank
you
for your prompt response!

"T. Valko" wrote:

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.