Trying to count text for filtered column based on formula

[Guest]

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_new)-MIN(ROW(date_new)),,1)),--(date_new,"cash)

 

[Guest]

try:

=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX(date_new,1,1),ROW(date_new)-ROW(INDEX(date_new,1,1)),0))=1),--(date_new="cash"))

hope this helps
Rowan

 

[Guest]

Rowan,
Thanks. That worked great.

try:

=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX(date_new,1,1),ROW(date_new)-ROW(INDEX(date_new,1,1)),0))=1),--(date_new="cash"))

hope this helps
Rowan

 

[Guest]

You're welcome. More detail at

http://www.xldynamic.com/source/xld.SUMPRODUCT.html