How sumifs can be replaced and how to break up the total value

[Meko1]

I am summing up the payments from one customer and using sumifs after which it gives me the total sum.
Example:
Imagine I have 50 names, and they all have the payments during a year in different dates.
The sumifs I am doing is- Look range, find criteria and from list of payments sum the total value.

At the moment I am trying to make excel to show the payments with the dates separately.

I tried lookup function but it does not quite work.
So do you have any advice how I can do it?

Thank you in advance

 

[Peter_SSs]

Can you give us a small set of dummy sample data and the expected results (with XL2BB so that we can copy/paste to test)?

 

[Meko1]

Product	Customer	Qtr 1	Qtr 2	Qtr 3	Qtr 4
Alice Mutton	ANTON	$ -	$ 702.00	$ -	$ -		Sumifs for allice mutton
Alice Mutton	BERGS	$ 312.00	$ -	$ -	$ -		2667.6
Alice Mutton	BOLID	$ -	$ -	$ -	$ 1,170.00
Alice Mutton	BOTTM	$ 1,170.00	$ -	$ -	$ -
Alice Mutton	ERNSH	$ 1,123.20	$ -	$ -	$ 2,607.15
Alice Mutton	GODOS	$ -	$ 280.80	$ -	$ -		Date		Payments
Alice Mutton	HUNGC	$ 62.40	$ -	$ -	$ -		01/01/2000
Alice Mutton	PICCO	$ -	$ 1,560.00	$ 936.00	$ -		02/01/2000
Alice Mutton	RATTC	$ -	$ 592.80	$ -	$ -		16/05/2001
Alice Mutton	REGGC	$ -	$ -	$ -	$ 741.00		12/03/2002
Alice Mutton	SAVEA	$ -	$ -	$ 3,900.00	$ 789.75		…
Alice Mutton	SEVES	$ -	$ 877.50	$ -	$ -
Alice Mutton	WHITC	$ -	$ -	$ -	$ 780.00
Aniseed Syrup	ALFKI	$ -	$ -	$ -	$ 60.00
Aniseed Syrup	BOTTM	$ -	$ -	$ -	$ 200.00
Aniseed Syrup	ERNSH	$ -	$ -	$ -	$ 180.00
Aniseed Syrup	LINOD	$ 544.00	$ -	$ -	$ -
Aniseed Syrup	QUICK	$ -	$ 600.00	$ -	$ -
Aniseed Syrup	VAFFE	$ -	$ -	$ 140.00	$ -

So As an example I took some data from Excel Sales report.
On its right I wrote Sumifs and with random Dates and Payments.
So I want my total to be broken into parts, what I mean is for a specific date to see how much the payment amount is.
You may say that I can just copy paste, but its the small range atm. If I had hundreds of payments and not in order like this it would be very difficult to find them all by hand and after to copy. So I hope there can be some kind of formula which will eliminate the extra steps.

 

[Peter_SSs]

Thanks for the sample data but does it show the expected result(s) that I asked for as that isn't obvious to me?

Also, at the right you have some dates but the data table has no dates so I don't know how those dates relate to getting the results you want.

So can you post the sample data again but include the results and an explanation of how those results are obtained manually?