Try this:

Column A = expenses
Column B = X or empty

Sum of expenses where column B is empty:

=SUMIF(B:B,"<X",A:A)

Biff

"GM" wrote in message
...
Hi.
I'm rather new when it comes to using Excel, so excuse me if my question
might seem simple. I run a small company and try to manage my
income/outcome
through Excel. One thing that takes a lot of time is calculating what
bills
have been paid and how much I still have left to pay. So far I've made 2
columns, one with an average of 400-500 different expenses, and another
right
next to it marked with an X for paid bills and an empty cell for Unpaid
bills... Each time I need to figure out my total amount left to pay, I
have
to create a new function for all the unmarked cells... Is there a formula
that I could use so that I don't have to spend half a day counting and
selecting all the unpaid ones? Hopefully you understand what I mean...
Thank
you in advance.