LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GM GM is offline
external usenet poster
 
Posts: 23
Default Calculating Paid and unpaid bills.

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LISTS OF BILLS TO BE PAID cookster Excel Worksheet Functions 1 February 7th 06 10:36 AM
track unpaid invoices mukesh Excel Worksheet Functions 2 February 7th 06 01:35 AM
macro for unpaid rent constance Excel Discussion (Misc queries) 1 March 21st 05 01:20 PM
macro for unpaid rent constance Excel Discussion (Misc queries) 2 March 21st 05 12:19 PM
Subtracting paid hours from unpaid hours ejerry7 Excel Worksheet Functions 5 November 29th 04 04:16 AM


All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"