Question description:
This user has given permission to use the problem statement for this
blog.
Need to sum a count of Sales which were refunded for a specific person.
Solved by Z. H. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/11/2017 - 06:19
Hello :)
User
29/11/2017 - 06:19
Hi
Excelchat Expert
29/11/2017 - 06:19
Can you share your sheet?
User
29/11/2017 - 06:20
Should I give you the example?
Excelchat Expert
29/11/2017 - 06:20
That'd be perfect.
User
29/11/2017 - 06:22
Now I need to calculate the amount which was refunded for each person
Excelchat Expert
29/11/2017 - 06:22
sure. I'll show you how to do that.
User
29/11/2017 - 06:22
There will be another sheet where it is calculating
User
29/11/2017 - 06:22
this is just a raw data
Excelchat Expert
29/11/2017 - 06:23
That will be Sheet2 in this example.
User
29/11/2017 - 06:23
Got you
Excelchat Expert
29/11/2017 - 06:24
https://docs.google.com/spreadsheets/d/1kskqAnAR_Qndmmp10Gd5hm9QhZO01yRDr4yI1mgeHFs/edit?usp=sharing
Excelchat Expert
29/11/2017 - 06:24
Please follow along using this sheet.
Excelchat Expert
29/11/2017 - 06:24
Nevermind, I'll just use this example to the right.
User
29/11/2017 - 06:24
Thanks
User
29/11/2017 - 06:25
You are great
Excelchat Expert
29/11/2017 - 06:25
Can I create a helper column that concatenates the name and Refunded?
User
29/11/2017 - 06:25
Please try
User
29/11/2017 - 06:26
If i will have confusion I will let you know
Excelchat Expert
29/11/2017 - 06:26
Okay, sounds good.
User
29/11/2017 - 06:27
Time is running
Excelchat Expert
29/11/2017 - 06:27
Yup, I'm over half done.
User
29/11/2017 - 06:27
ok
User
29/11/2017 - 06:30
Hey Bro - Whats up?
Excelchat Expert
29/11/2017 - 06:30
I'm here.
Excelchat Expert
29/11/2017 - 06:30
I'm changing formulas will be done shortly.
User
29/11/2017 - 06:31
ok
Excelchat Expert
29/11/2017 - 06:32
=sumifs(Sheet1!$C$4:$C$9,Sheet1!$B$4:$B$9,A2,Sheet1!$D$4:$D$9,"Yes")
Excelchat Expert
29/11/2017 - 06:32
There is your formula
Excelchat Expert
29/11/2017 - 06:32
This is complete.
Excelchat Expert
29/11/2017 - 06:33
See Sheet2.
User
29/11/2017 - 06:34
I will try, And are you from India?
Excelchat Expert
29/11/2017 - 06:34
No I am not.
User
29/11/2017 - 06:34
ok, Whats your location?
Excelchat Expert
29/11/2017 - 06:35
The US.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.