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

Meko1

New Member
Joined
Oct 20, 2020
Messages
44
Office Version
  1. 2016
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

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

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,526
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Oct 20, 2020
Messages
44
Office Version
  1. 2016
Platform
  1. Windows
ProductCustomerQtr 1Qtr 2Qtr 3Qtr 4
Alice MuttonANTON$ -$ 702.00$ -$ -Sumifs for allice mutton
Alice MuttonBERGS$ 312.00$ -$ -$ -2667.6
Alice MuttonBOLID$ -$ -$ -$ 1,170.00
Alice MuttonBOTTM$ 1,170.00$ -$ -$ -
Alice MuttonERNSH$ 1,123.20$ -$ -$ 2,607.15
Alice MuttonGODOS$ -$ 280.80$ -$ -DatePayments
Alice MuttonHUNGC$ 62.40$ -$ -$ -01/01/2000
Alice MuttonPICCO$ -$ 1,560.00$ 936.00$ -02/01/2000
Alice MuttonRATTC$ -$ 592.80$ -$ -16/05/2001
Alice MuttonREGGC$ -$ -$ -$ 741.0012/03/2002
Alice MuttonSAVEA$ -$ -$ 3,900.00$ 789.75
Alice MuttonSEVES$ -$ 877.50$ -$ -
Alice MuttonWHITC$ -$ -$ -$ 780.00
Aniseed SyrupALFKI$ -$ -$ -$ 60.00
Aniseed SyrupBOTTM$ -$ -$ -$ 200.00
Aniseed SyrupERNSH$ -$ -$ -$ 180.00
Aniseed SyrupLINOD$ 544.00$ -$ -$ -
Aniseed SyrupQUICK$ -$ 600.00$ -$ -
Aniseed SyrupVAFFE$ -$ -$ 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
Joined
May 28, 2005
Messages
47,526
Office Version
  1. 365
Platform
  1. Windows
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,119,220
Messages
5,576,805
Members
412,748
Latest member
MikeyP14
Top