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:))

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:))

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:))

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:))