Searching Table Skipping/without Zero

[aamirsq]

Hi,
Greetings Happy new year 2017,

I am trying to create a summary from a table but zeros are making problem for me.

Any ideas. I just want to add only products which were sold to any company.

Thanks

 

[John Jairo V]

Hi!

Why not =SUM(E2:E30) ? Blessings!

 

[aamirsq]

Well, the problem is not N6 its M6 .
I want to write in M all companies for which 6 came in one column.

 

[John Jairo V]

Hi again!

Check please the file. I put 3 options to you. Blessings!

 

[aamirsq]

For Option 2 and 3 !
I use mostly office 2013, sharing would create problem also noticed when any company is completely removed summary gives error in Option 2.

Option 1:
But I prefer formulas instead of vb, as while sharing people are afraid of script codes and even sometimes file gets blocked.

Thanks

 

[John Jairo V]

Hi again @aamirsq

Check this option, with helper column (Column I). Change the product in K2. Blessings!