EXCEL formula - SumIF

Hi,

We have the below formula, but would like to know if this could be amended to show only results from visible cells in that range rather than all cells.

So if we had the data filtered the results from the formula would be on the filtered data and not the whole data.

=SUMIFS(PREMIUM!$J$2:$J$80674,PREMIUM!$G$2:$G$80674,">="&$A8,PREMIUM!$G$2:$G$80674,"<"&$A9,PREMIUM!$H$2:$H$80674,"1")

At the moment the data it is pulling this from is not formatted as a table but this could be done if needed.

Thank you.

Sam