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

#### Meko1

##### New Member
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?

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### Peter_SSs

##### MrExcel MVP, Moderator
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

##### New Member
 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

##### MrExcel MVP, Moderator
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?

Replies
1
Views
80
Replies
7
Views
236
Replies
2
Views
263
Replies
3
Views
248
Replies
0
Views
155