| 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:)) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to count text for filtered column based on formula
try:
=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX(date_new,1,1),ROW(date_ne w)-ROW(INDEX(date_new,1,1)),0))=1),--(date_new="cash")) hope this helps Rowan "dtg_denver" wrote: 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:)) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to count text for filtered column based on formula
Rowan,
Thanks. That worked great. "Rowan" wrote: try: =SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX(date_new,1,1),ROW(date_ne w)-ROW(INDEX(date_new,1,1)),0))=1),--(date_new="cash")) hope this helps Rowan "dtg_denver" wrote: 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:)) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Trying to count text for filtered column based on formula
You're welcome. More detail at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html "dtg_denver" wrote: Rowan, Thanks. That worked great. "Rowan" wrote: try: =SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX(date_new,1,1),ROW(date_ne w)-ROW(INDEX(date_new,1,1)),0))=1),--(date_new="cash")) hope this helps Rowan "dtg_denver" wrote: 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:)) |
| Reply |
| 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 | |||
Hybrid Mode
