Visible Rows, Dynamic Row Numbering, Conditional Formatting, and Formulas

Using Subtotal on every row of your range table, you can display sequential row numbers for visible rows only. With that you can also fill every other row with a cell color just like a defined Excel Table even when rows are filtered. You can also use ****IFS functions to get results for visible rows only.

Dynamic Row Numbering
The Key to the whole thing is the formula in cell A3. It shows a row number only if the row is visible (not filtered out).
=LET(VIS,SUBTOTAL(103,B3),IF(VIS=1,VIS+MAX(A$2:A2),0))

Dynamic CF
To get Conditional Formatting to fill cell color for alternating rows, use this formula. Even if you filter out rows, the CF will show correctly
=MOD($A3,2)=0
If you want to color every third row use
=MOD($A3,3)=0

Dynamic Functions
And then finally to get the Sum, count, max, min, or average value of just the visible cells, use a formula like this. The bold part specifies to use only cells in column A that are not zero. You can also use FILTER with other functions for a wider variety of results
=COUNTIFS(C3:C162,"Active",A3:A162,"<>"&0)