Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Offset, Dynamic range, Countif
I need to count the # specific items within a list of data (in Column K).
Column K data is limited to four "Status" responses ("Confirmed" "Good" "Bad" "Non-Responsive"). The corresponding dates (in Column J) tells me the date these items were entered into system. I would like to have a formula which looks at the date within cell A3 (a variable input cell allowing me to search using a specific date) and looks only within the date range under column J and counts the # of "Non-Responsive" cells under column K (still abiding by that date cell range). I have tried many diff ways but am having trouble utilizing the offset function (I've never used it). Please help me out guys. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
Chart attached to dynamic range | Charts and Charting in Excel | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Reference to a dynamic range | Excel Discussion (Misc queries) | |||
Add a Dynamic Range with 2 Conditions Q | Excel Worksheet Functions |