Need Help to find unique sum of products

[Siddiq Sayed]

Hi,

I have a small file where the product sold is kept as week number and then unique ban no. i want to find the sum of all procucts in a particular week with unique ban no.

 

[Somendra Misra]

Hi Siddiq,

Welcome to Chandoo's forum.

Can you explain your data what are the different fields and what sum you want?

Like what is ADSL/LOCAL and other fields?

Regards,

 

[Siddiq Sayed]

I want to sum the product ADSL with Weekwise and then tanking only unique ban numbers. Then same for Local, TSTV and TTV. I want to use the sumifs function as i have used the sumifs if the entire sheet

 

[Somendra Misra]

I want to sum the product ADSL with Weekwise and then tanking only unique ban numbers. Then same for Local, TSTV and TTV. I want to use the sumifs function as i have used the sumifs if the entire sheet

See the file with pivot table, comment on the layout and numbers.

Regards,

 

[Faseeh]

Hi Siddiq,

This is formula based version.

 

[Siddiq Sayed]

Hi Somendra / Faseeh

Thank you so much for the reply. Would it be possible to get only the unique count of BAN no according to the week no eg :-

Week Count of Unique BAN
20150104 7

 

[Somendra Misra]

Hi Somendra / Faseeh

Thank you so much for the reply. Would it be possible to get only the unique count of BAN no according to the week no eg :-

Week Count of Unique BAN
20150104 7

See this file. (Yellow Cells)

Regards,

 

[Siddiq Sayed]

Thank you very much Somendra. Appreicate your help.

 

[Siddiq Sayed]

Hi Somendra,

Would it be possible that you can include another condition in the above formula that mktcode should only be TTV. The unique count of BAN should only be with the mktcode that has TTV.

 

[Somendra Misra]

Sure , see this file.

Regards,

 

[Siddiq Sayed]

Thank you very much Somendra. No words to thank you. will get in touch again if stuck.