Is there a replacement for the Intermediate.Totals function?

Question

excel

I can’t write a formula that would sum up the values ​​in the cells located in column C, provided that the filtering is set on specific values ​​​​from column B and at the same time the calculation was carried out on specific values ​​​​in cell A.

In simple terms, then you need to sum those cells C, which correspond to a specific month in A for a specific item B.

I'm stuck in Google for half a day, I tried using the IF function (I tried to create a condition like

=IF(COUNTIF(A1:C5000,"February");SUBTOTAL(9,C1:C5000),"")

- works, but, unfortunately, not for visible cells, but for all.

Also, through

SUBTOTALS

, respectively. It summarizes the visible cells, but without the condition of the neighboring cell in A.

I don’t understand through which function this can be implemented.

I am making the spreadsheet on MS Excel 2019. I
created a test version https://docs.google.com/spreadsheets/d/1vpAAq9bIqo...
Filtering is configured.

Answer 1

1. If you manually hide lines, use 109, not  9.
   
2. The solutions for the links that Yandex displays upon request промежуточные итоги с условием в excelare not compatible [for me] with Google Spreadsheets (I can’t check in Excel).
   
3. Achieving the desired result is easy with the SUMIFS function:

   =СУММЕСЛИМН(C2:C73;A2:A73;"Февраль";B2:B73;"Тест 1")

   An explicit indication can be replaced by cells in which the conditions will be written: =СУММЕСЛИМН(C2:C73;A2:A73;A75;B2:B73;B75)A75="February", B75="Test 1"
   
4. Why do you need additional condition, if using =ПРОМЕЖУТОЧНЫЕ.ИТОГИ(109;C2:C73)and filtering on two columns at once, you will get the desired result?