Forum Discussion
waheedafsar
Sep 03, 2022Copper Contributor
I need Formula?
Dear All, Please help me below, Style Description Rate Remarks GPW-930 Shirt 2 1st Half GPW-930 Trouser 100 GPW-930 Dupatta 20 GPW-930 Shirt 250 ...
HansVogelaar
Sep 03, 2022MVP
You could create a pivot table based on the data.
If you prefer a formula:
Let's say your data are in A1:D5, with headers in A1:D1.
Enter the style name in for example F1 and the description in G1. Then enter the following formula in H1:
=SUMIFS($C$2:$C$5, $A$2:$A$5, F1, $B$2:$B$5, G1)