I need a way to count subtotals if they meet a qualifying condition.
I have the subtotals in place.
What I am trying to do is count how many customers via their email addresses purchased 1 transaction, 2 transactions, 3 transactions, and so forth – based on the subtotals.
Is this possible? Please let me know if this is not clear enough.
Please upload a sample workbook containing the setup of your data.
Spread the love, add to the Rep
"None of us are as smart as all of us."
Example attached.
To be a little clearer. Customer 1 and Customer 9 bought six products, based on the subtotals. I need to find a way to count how many customers bought six products.
Thanks!
Try this:
Will that work?
Please Login or Register to view this content.
With 6 total:
=COUNTIFS($A$2:$A$70,"*Total*",$B$2:$B$70,6)
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks