combine 4 columns

Question

Hello,&nbsp;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 measure which we need to be calculated separately. Thank you&nbsp;

preagan · Answer

Hello&nbsp;AnisM85,&nbsp;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))&nbsp;Note: This formula assumes you have nothing above or below your data table.

anism85 · Answer

Thank you for your replyPReagan&nbsp;&nbsp;however it didn't work for some reason, any other suggestions?&nbsp;Thank you

sergeibaklan · Answer

AnisM85&nbsp;
I guess you forgot to wrap by SUMIF

anism85 · Answer

I&nbsp;attached&nbsp;the wrong picture&nbsp;SergeiBaklan&nbsp; but thank you anyway&nbsp;

preagan · Answer

Hello&nbsp;AnisM85,&nbsp;I apologize. My formula was based on a table with only two columns. Please use the following formula instead:&nbsp;=SUMIF(OFFSET($A$1,0,0,COUNTA(A:A),1),$A1,OFFSET($C$1,0,0,COUNTA(C:C)))

Forum Discussion

combine 4 columns

6 Replies

Resources