I would like to count # of occurences but have it be dynamic when.
 

i know there has to be a way to do this, but having trouble piecing the
formula together. I want it to work like the subtotal(9) works.

Hi

could you repost with a short description in the subject line and your
entire question in the message body as the subject line gets truncated and
unfortunately, in this case, i've got no idea what you're after - unless,
you're looking for the COUNTIF function.

Cheers
JulieD

"Sifedirector" wrote in message
...
i know there has to be a way to do this, but having trouble piecing the
formula together. I want it to work like the subtotal(9) works.