subtotal function

[Greg]

This is sort of a continuation of my question from this morning. Is there a
way to use the subtotal function with anything other than the 11 that I have
found listed? From what I can tell the function is laid out like
=SUBTOTAL(2,D61000) and that will get me a total count when I use the
filter. Now I am trying to see if I can somehow replace the number 2 with
something that will do countif so I can count how many "Yes" fields there are
left in the filtered list. any ideas?

 

[Mike H]

Greg,

Subtotal needs a little help to do that.

=SUMPRODUCT(SUBTOTAL(3,OFFSET(D61000,ROW(D61000)-MIN(ROW(D61000)),,1))*(D61000="Yes"))

Mike

 

[Greg]

That got it. I will have to cut up that code and figure out how that worked.
thank you.