| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to count text for filtered column based on formula
I'm using the formula below to count records based that are 0 . I need to do
the same in a column that has text. Need to count "Cash". Get error =SUMPRODUCT(SUBTOTAL(3,OFFSET(date_new,ROW(date_ne w)-MIN(ROW(date_new)),,1)),--(date_new,"cash:)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count text string in column cells of filtered rows | Excel Worksheet Functions | |||
| count filtered rows based on condition greater than forty | 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
