Hi all excel expert,
Need help as above mentioned in my subject.
Example I have data below pulled from system which consist of duplication lines with same spend. Any excel formula can help to sum the "weekly spend" by only count once the duplication lines which will return a result of $ 1270.00. But I need a formula of subtotal which the sum only those visible lines with filter by "Name".
I had tried =SUMPRODUCT(B1:B10/COUNTIF(A1:A10,A1:A10)) but this formula cannot cater the subtotal features and sum value is included hidden line when i filter by "Name".
Name Weekly Spend
Betty $60.00
Calvin $200.00
Calvin $200.00
Margaret $100.00
Michael $100.00
Peter $150.00
Rachel $120.00
Steve $300.00
Tracy $240.00
Tracy $240.00
Bookmarks