# Excel - COUNT Function Problem - Expert Solution

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
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
Excelchat Expert 29/11/2017 - 06:24
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
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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.