Try this:

Assume column headers are in the range B1:K1
Sales figures in the range B2:K2. There is only numbers or empty cells in
this range.

=IF(COUNTIF(B2:K2,"0"),LOOKUP(2,1/(B2:K20),B1:K1),"")

--
Biff
Microsoft Excel MVP


wrote in message
...
Hi all - I have the following columns and data
My Column headers are Item Code - Item Description and then Week
numbers for the year
The amount of sales for each item are scattered under the week number
- there are some empty cells and some cells contain 0