**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.*