How do exclude hidden Cells in my CountIfs formular

[Laila3006]

Hi

I have a spreadsheet whit a lot of data for en entire year.
I need to count the amount of data within a specific date range and rows containing specific letter.
The letters are in Coulumn G and there are a lot of different letter combination. I figured that it would be a lot easier to filter the non-usable away, then adding them to theformula.

My current formula reads:

=COUNTIFS(C$3:C$1048576,">="&K3,C$3:C$1048576,"<="&EOMONTH(K3,0))

Now I just need it to NOT count the hidden rows.
Hope you can help.

Best Regard
Laila

 

[James006]

Hi,

To count visible rows, you can test = SUBTOTAL(3, C3:C1048576)

HTH