Using SumIf With Subtotal Formula And Autofilter

Just to give you a quick overview (i cannot attach workbook due to data protection for our customer), I have a workbook with two tabs on it, an invoice summary tab and a rentals tab.

This is an extract of the table from my invoice summary tab:

Tab
Net (Zero Vat)
Net (Standard Vat)

Initial Rentals
Rentals
0

[Code] .....

The invoice data is on the rentals tab. Column "C" on the rentals tab details what type of rental it is, as per column A in the table above. the amount to sum on my rentals tab is in column "S".

I have a formula currently which looks like this:

=SUMIF(Rentals!$C:$C,'Invoice Summary'!$A2,Rentals!S:S)

this works fine.

Now the problem i have is i have an autofilter on the rentals tab which will be filtered by different accounts, I need the formula on the invoice summary tab to only show the visible amounts (as per the filter) and not the whole column. I was thinking of a subtotal formula but can't use a sumif and subtotal together (i dont think).