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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add a series of cells?
If values are in a2:a100 and pending etc in cells b2:b100 and the reference at the top is in cell c1 sumif(b2:b100,c1,a2:a100) regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=573829 |
Reply |
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) |