Forum Discussion

waheedafsar's avatar
waheedafsar
Copper Contributor
Sep 03, 2022

I need Formula?

Dear All,

                Please help me below,

 

StyleDescriptionRateRemarks
GPW-930Shirt21st Half
GPW-930Trouser100 
GPW-930Dupatta20 
GPW-930Shirt2502nd Half

 

I want to sum up values like style and description. I enter the style name and description in excel automatically some all related matters like GPW-930 Shirt sum = 252 please give me the formula.

excel
Formulas and Functions

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 03, 2022

    waheedafsar 

    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)

Resources