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,D6:D1000) 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?

Greg,

Subtotal needs a little help to do that.

=SUMPRODUCT(SUBTOTAL(3,OFFSET(D6:D1000,ROW(D6:D100 0)-MIN(ROW(D6:D1000)),,1))*(D6:D1000="Yes"))

Mike

"Greg" wrote:

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,D6:D1000) 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?

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

"Mike H" wrote:

Greg,

Subtotal needs a little help to do that.

=SUMPRODUCT(SUBTOTAL(3,OFFSET(D6:D1000,ROW(D6:D100 0)-MIN(ROW(D6:D1000)),,1))*(D6:D1000="Yes"))

Mike

"Greg" wrote:

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,D6:D1000) 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?