Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add a series of cells?
I have a spreadsheet with a series of drop down boxes with multiple values.
Is it possible to set up a formula that will add only those cells adjacent to certain values? As an example, if the drop down has options such as PENDING and CLOSED but I want to have the system automatically add only the dollar amounts next to PENDING. Then, when it changes to CLOSED, I would like the system to automatically re-calculate and shift the specific amount from PENDING to CLOSED, can that be done? If so, how? Any assistance will be greatly appreciated. Thanks. J-P |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
How to fill cells with a different kind of series? | Excel Worksheet Functions | |||
how to save/copy data in cell to a series of cells on another pg | Excel Worksheet Functions | |||
Sum the results of an equation through a series of Cells | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |