Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LISTS OF BILLS TO BE PAID | Excel Worksheet Functions | |||
track unpaid invoices | Excel Worksheet Functions | |||
macro for unpaid rent | Excel Discussion (Misc queries) | |||
macro for unpaid rent | Excel Discussion (Misc queries) | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |