Using this QUERY which will give a complete table, and has been added to your file, you will notice that your data is not clean, meaning that there are hidden spaces so names appear to be duplicated.
=QUERY(REFUND!F:I, "select F, count(H), sum(I) where H='REFUNDED' group by F label count(H) '# Refunds', sum(I) 'Amount'",1)
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks