Count in various cells using LOOKUP - hide empty rows???

Hi All,

I am having great difficulties....!

Here is the scenario. I have a number of vans whom are allocated between 1 of 100 potential different magazines by a client (attached only has 30 examples on 10 vehicles). The client data format is fixed (although the order and number of the magazines (in ROW 4) is variable on a daily basis). We have created a formula that calculates the sum of specific magazines per van in a summary page but cant manage to do the same for the "count function". Any ideas?

Also pushing my luck now.... because at any given time we may only work with 5 - 10 of the 100 products (rows of data in the summary tab), can you automatically hide any rows that don't have any values in the summary sheet, so it is more print / user friendly?

Thanks in advance,

Mark