Please upload your file (not a screenshot). I will be much easier to help that way. 

Hi Mr. Riny,

           Just i finished this formula for above query, =SUMIF(N6:FO6,"<>",$N$4:$FO$4) and thanks for your reply.

Could you please help me other query, i have updated a Article Code in i3 to o3, this details need to update in G column based on while i entered i6 to o17 data's.

I created an area with formulas (I30:O41) that do what I think you need. But please check, since my numbers don't match the ones you entered manually. If it's correct, I assume you can manage to enter my formulas in the correct place.

Hi Riny,

            Sorry i think i was wrongly explain you, i have a article code in i3 to o3, this data i need to fill in G column 

based on while i entered norms in ( i6 : o17 ).

If i entered two norms in two cell data article code should merged e.g. 20138,20137,

Article Code

Hello,

I assume you have Microsft 365.

In G6, paste in following formula and then copy down.
=TEXTJOIN(",",TRUE(),FILTER($I$3:$O$3,ISNUMBER(I6:O6),""))

See attached file for an example.

Br,
Anders

Hi Goodmorning Mr. Anders ,

 filter formula not working in my office i m using 2019 excel. can you please give me other option to use.          

Hello,

=TEXTJOIN(",",TRUE(),IF(($I$3:$O$3)*(ISNUMBER(I6:O6))<>0,($I$3:$O$3)*(ISNUMBER(I6:O6)),""))

Br,
Anders

Hello Anders,

Thanks for your support its working fine.

=TEXTJOIN(",",TRUE(),IF(($I$3:$O$3)*(ISNUMBER(I6:O6))<>0,($I$3:$O$3)*(ISNUMBER(I6:O6)),""))

How can i use this formula if i use article name in (Text).

Hello,

You can use ISTEXT instead for such scenario.

Br,
Anders

Hi,

        Well noted and thanks for your support.