| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to count text in a filtered array using this function
I'm counting based on a filtered spreadsheet. I use this formula that works
great if I test for 0. However when I try to count the "Cash" entries I get an error. SUMPRODUCT(SUBTOTAL(3,OFFSET(new_lender,ROW(new_le nder)-MIN(ROW(new_lender)),,1)),--(new_lender,"Cash") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count function in Auto-Filtered data | Excel Discussion (Misc queries) | |||
| Using Count Function on Filtered List | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
