Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming Conditional Sum Formulas
Help. I am so confused. I all of my customers accounts broke down in a
wokrbook by a worksheet for each. For each customer, I have used the conditional sum formula to calculate the outstanding invoices based on 0-30 days, 31-60 days, 61-90 days and over 90 days. Then I have another workbook called Current aging, in which I summarize the customers information with a link to their individual statement. My problem is that when invoices are paid or new ones are added, I have to add and delete rows from the individual statement, changing the location of the conditional sum formula, meaning that the link to the current aging does not come our correctly. Can anyone help me as to how I can fix this? Thank you in advance. -- Shelly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ARE THERE CONDITIONAL FORMULAS TO CHANGE TEXT COLOR? | Excel Worksheet Functions | |||
Conditional use of formulas | Excel Worksheet Functions | |||
Using MIN in Conditional Format for cells with Formulas | Excel Discussion (Misc queries) | |||
can conditional formulas be used in or with pivot tables | Excel Worksheet Functions | |||
how can i use colors in conditional formulas if i want the result. | Excel Discussion (Misc queries) |