Summing up as per the text

[Mohandas]

I want sum up as per the lead pack. no duplicates

 

[vijay.vizzu]

Not clear... can you please elaborate more. So that other can get your idea

 

[Mohandas]

i want to sum the numbers from jan to dec month wise with criteria lead pack for example scm retail is in 2 rows i want it only in 1 row the year total for scm retail should be 37, Please tell how to do it

 

[Somendra Misra]

@Mohandas

Still not clear. SCM Retail 400g is in ROW C6:C13. What output layout you are looking at? Kindly, upload a sample.

Regards,

 

[Mohandas]

This is the Desired output

 

[Mohandas]

Hope u guys understood

 

[Somendra Misra]

@Mohandas

Still not clear what you want. Your table showing the usage of SUM function. Row total and column Total.
Trying explaining your problem in words w.r.t to the upload file.

Regards,

 

[Mohandas]

In that file i have lead pack and normal pack i want to total lead pack and normal pack. For example Milk maid retail lead pack is 10 and normal pack is 10 the naswer should be 20

 

[Somendra Misra]

@Mohandas

Will check and get back to you. If I will have any doubt I will ask it.

Regards,