Banking summary help

Try

in F16
=SUMPRODUCT((LEFT('Payment Details'!$D$5:$D$1000,7)=$E16)*('Payment Details'!$B$5:$B$1000=F$15)*('Payment Details'!$A$5:$A$1000))
copy across and down as far as H25

Hi HK and welcome to the forum,

I built some fake data for you and then a Pivot Table from my data. See if it does what you want, in the attached..

Banking Summary Pivot.xlsx

Hey HK,

I do a banking workbook for my own in a slightly different way. I have a banking account and 2 credit card accounts that I use. Each of the 3 send me pdf files that I can download from their sites. Then I use a PDF program called Foxit PhantomPDF to convert all those monthly statements to Text files. I keep each accounts text files in different directories/folders. NOW - Using the new Power Query tool in Excel, I can pull in all the text files in a single folder. I build the power query to leave only 3 columns like you have; Date, Description, Amount. I pull all 3 accounts over to a single sheet and do an advanced filter and pivots on the data to analyze it.

The beauty of the above method is: each new month I simply add the statements text file into the folder and run the report again. The new month is included in the totals. No typing and Power Query works on all text files in the folder, even the new one I've added.

I haven't shown this to anyone yet as it is my personal account stuff but sometime in the future.

Yesterday I was going down the description list and could type in something like "Costco" and I have vba that converts that to "*Costco*" and puts this in the Advanced Filter area and filters my transactions to show records with Costco. I then can count, sum and even pivot by years. My wife doesn't like this ability much as I keep asking her "do you know who xxx" is? We send the 9.99 a month for the last 45 months.... She then needs to search the net and her LastPass list to see who the heck they are and realize we/she spends a lot of money on small stuff done a lot of times.

Initial thought would be that there might be an extra space in cells E21:E25. Otherwise it is hard to trouble shoot a screenshot, so I suggest that you upload the spreadsheets from which the screenshots were taken.
To upload a workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.