| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to count text string in column cells of filtered rows
Try this...
Assume the full unfiltered range is B2:B15. =SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B15,ROW(B2:B15)-ROW(B2),0,1)),--(B2:B15="pass")) -- Biff Microsoft Excel MVP "JSS" wrote in message ... What is the formula to return the number of specified matching text in a colukn but only for the rows showing after a filter is applied? Example: How many incidences of "Pass" are there if a filter is applied to see only dates 1/1/2009 and 3/1/2009? I tried =COUNTIF and I get the total of all "Pass". Not the filtered data. Date Result 1/1/2009 Pass 2/1/2009 Fail 3/1/2009 Pass 4/1/2009 Pass |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Advanced Filtered Rows | Excel Worksheet Functions | |||
| How do I count the number of filtered rows | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Threaded Mode
