| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum when cell's value in Named List
Hi,
Appreciate very much if someone could help me on this. I have the following: COL A Pear Celery Cherry Apple Cucumber Pear Apple Cucumber : : COL B 18 12 13 14 9 8 5 4 : : and a Named Range Define as Vegetable having Cucumber Celery I want to sum all rows of COL B where COL A falls in the Vegetable list.(Ans: 25). I dont want to have something like ..."Cucumber", "Celery"... because this Vegetable Named Range will append over time. Therefore I want to use a Name Range to have this flexibility. I believe Excel functions can do the job, hopefully not Pivot table or VB. I am using Excel 2007. Thanks for your help! Cheers. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| code to delete sheets not in use based on a cell's drop down list | Excel Worksheet Functions | |||
| Removing rows in which 1 cell's value appears on a separate list | Excel Discussion (Misc queries) | |||
| Changing named Validation list to Dynamic list. | Excel Discussion (Misc queries) | |||
| Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
| Changing named range reference depending on a cell's content | Excel Discussion (Misc queries) | |||
Threaded Mode
