Count Total Records on a filtered form based upon the value of a cell

[kengooch]

I need to count the total records on a form that is filtered by Staff Member and then within that filter, I need to total all records where the expiration date is 1 week out. I filter the form based upon the name in Column "A" using VBA Code.

I can Count the total records on the filtered form with the following equation =(SUBTOTAL(103,G:G)-3)
Then I need to count all cell's in column G that are <8 which would give me the count of records that expire in 1 week or less.

How can I create an equation to give me that total count, but only for the filtered records?

Thanks so much for your help in advance!
Ken

 

[Gasman]

CountIfs() ?