S Sarfraz Khan Member Sep 10, 2015 #1 Dear Sir, Based on attached sheet I want result like total of each customer, using formula. Attachments Subtotal Help.xlsx 8.4 KB · Views: 5
eibi Active Member Sep 10, 2015 #2 Try this formula in cell E7: =SUMPRODUCT(($A$7:$A$30=A7)*$B$7:$B$30) See attached. Attachments sarfraz khan2.xlsx 9.1 KB · Views: 7