Countifs number of transactions within month and year and match specific location

Greetings for the day guys.

in the attached Excel sheet, from the data range, I need to use a formula in the report summary table, for example, J3 should give me the total number of transaction that was made in the month of Jan year 2022 @ J2 , the data range is in column D, but at the same time it should extract only transaction from location 135 in I3, the data range is B column.

also, I need to use a formula in the report summary table, for example, K3 should give me the total amount of transaction that was made in the month of Jan year 2022 @ K2 , the data range is in column G, but at the same time it should extract only transaction amount from location 135 in I3, the data range is B column.


I look forward to finding the right formula for that case.

many thanks for considering my request.

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ml#post5812354