| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a cell to count values from a list dependent on anoth
My first tab is a summary and looks something like this
A1 B1 C1 D1 Status Total D F New 5 2 3 Analysis 2 0 2 Analysis Completed 3 3 0 So, the information in the B column is being pulled from =COUNTIF(STATUS;Analisys!BA1) The information in the columns C and D is dependent on the list STATUS but is being inputted manually at the moment The STATUS list has 5 returns of new. Contained within this tab where the list STATUS is found the column adjecent to this has either D or F in the field. eg. new D new F new D new F new F I am after a formula that will update this on the summary page. Thanks to anyone who can help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count the number of 'values' in a cell | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count the number of specific values in a cell | Excel Worksheet Functions | |||
Threaded Mode
