Calculating Paid and unpaid bills.

[Guest]

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.

 

[Guest]

If your amounts were in column A and your column with the x's were in column
B, the formula would be:

=SUMIF(B1:B500,"<>x",A1:A500)

Congrats on owning your own business. But if you are not an excel expert,
you might want to get some simple software or existing Excel templates rather
than programming your own accounting system! We're happy to help, but
suspect you have better things to do . . .

 

[T. Valko]

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