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.

As you can see in the attached screenshot I used the Slicer option, but instead, I want to use the formula as mentioned above.

I can't attach an Excel file I have no idea why, so I shared a screenshot instead!

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

many thanks for considering my request.


example.jpg

Common mistake : applying manual column alignment before making sure everything works. Your sales location in col B are text ( looking like numbers), those on col I are real numbers.
When no alignment is applied , text aligns left and numbers right.
Nice layout though ! ( why not use a simple Pivot Table?)

Like this?

Originally Posted by Pepe Le Mokko

Like this?

Thank you brother this is brilliant, I just realized that I need the Furmola to give me an additional extracting result for sale as well.

so I have just added one more criteria to the formula, J1 is the zone code so the result in J3 is now extracting the same way but also doing an additional match with zone codes in column C .


However in the K column can I have the same way working for the sale if we assume that sales figures are in column G.

I look forward to your supportive resolution.

I'm having trouble with my account otherwise ill upload the updated sheet with sales amounts.

example.jpg