SUMIFS Ammount of transactions within month and year and match specific location

**MAJID1479** · 04-09-2023, 04:55 AM

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

=SUMPRODUCT(--($B$19:$B$50673=$K3&"")*($C$19:$C$50673=$M2&"")*(YEAR($D$19:$D$50673)=YEAR(L$2))*(MONTH($D$19:$D$50673)=MONTH(L$2)))
The above formula is what I used in L3 to get the number of transactions according to the criteria .

i want the same things to work with SUMIFS in M3 as indicated in my first paragraph.

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

Showroom Delivery Tracker-.xlsx

**TMS** · 04-09-2023, 05:19 AM

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

Try again.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

**MAJID1479** · 04-09-2023, 05:32 AM

Originally Posted by TMS

Try again.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

unfortunately its not working , same error appear again ; "www.excelforum.com says The following errors occurred:
Showroom Delivery Tracker-.xlsx: Upload of file failed."

**TMS** · 04-09-2023, 06:58 AM

How big is the file? We only need a small sample that gives enough information to develop and test a solution. As such, it needs enough records of varying dates, etc.

**MAJID1479** · 04-09-2023, 06:59 AM

Originally Posted by TMS

How big is the file? We only need a small sample that gives enough information to develop and test a solution. As such, it needs enough records of varying dates, etc.

the file size is 4.61 MB (4,841,090 bytes)

**MAJID1479** · 04-09-2023, 07:22 AM

Originally Posted by TMS

How big is the file? We only need a small sample that gives enough information to develop and test a solution. As such, it needs enough records of varying dates, etc.

I have already reduced the size of the file, it's already attached to the thread.

I look forward to your support on the given thread above.

**Marc L** · 04-09-2023, 07:25 AM

Any VBA question, the purpose of this forum section ?!

**MAJID1479** · 04-09-2023, 08:12 AM

Originally Posted by Marc L

Any VBA question, the purpose of this forum section ?!

I'm looking for a suitable formula that can give me the result of SUMIFS scenario.

please refer to my main objective thread.

**bebo021999** · 04-09-2023, 10:13 PM

Try countifs and sumifs:
L3:

Please Login or Register  to view this content.

M3:

Please Login or Register  to view this content.

And upgrade:
I3:

Please Login or Register  to view this content.

J3:

Please Login or Register  to view this content.

**MAJID1479** · 04-11-2023, 11:31 AM

Originally Posted by bebo021999

Try countifs and sumifs:
L3:

Please Login or Register  to view this content.

M3:

Please Login or Register  to view this content.

And upgrade:
I3:

Please Login or Register  to view this content.

J3:

Please Login or Register  to view this content.

this is so brilliant brother, thank you so much it's a great help, much appreciated.
fantastic resolution

SUMIFS Ammount of transactions within month and year and match specific location

LinkBack

Thread Tools

Rate This Thread

Display

SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Re: SUMIFS Ammount of transactions within month and year and match specific location

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Countifs number of transactions within month and year and match specific location

[SOLVED] Countifs number of transactions within month and year and match specific location

[SOLVED] Return a specific Year if the month is the last month of the current Year

[SOLVED] Looking for a SUMIFs formula that populates both on the month and specific year

Count number of entries if month and year correspond to specific month and year.

[SOLVED] SUMIFS formula needed when specific month, quarter, or year selected

[SOLVED] Formulas for Subcategory Amounts Based on Month and Year from Transactions Sheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions