Forum Discussion

AnisM85's avatar
AnisM85
Copper Contributor
Jan 08, 2020

combine 4 columns

Hello,   Can some help me combine the attached data? the object is to get the total quantity of each description. note that all description has the same code, but might have a different unit of mea...
excel
PReagan's avatar
PReagan
Bronze Contributor
Jan 08, 2020

Hello AnisM85,

 

Try this starting in cell E1:

=SUMIF(OFFSET($A$1,0,0,COUNTA(A:A),1),$A1,OFFSET($B$1,0,0,COUNTA(B:B))

 

Note: This formula assumes you have nothing above or below your data table.

  • AnisM85's avatar
    AnisM85
    Copper Contributor
    Jan 09, 2020

    Thank you for your replyPReagan 

     

    however it didn't work for some reason, any other suggestions?

     

    Thank you

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 09, 2020

      AnisM85 

      I guess you forgot to wrap by SUMIF

      • AnisM85's avatar
        AnisM85
        Copper Contributor
        Jan 13, 2020

        I attached the wrong picture SergeiBaklan  but thank you anyway

         

Resources