On Feb 10, 11:53*pm, "T. Valko" wrote:
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- Hide quoted text -

- Show quoted text -

Biff - thanks so much - works perfectly. I'm trying to figure out how
it works - I read up on the Lookup function - the part I'm trying to
get is the 2,1/(B2:K20) part - why 2 and why 1 divided by the
reference. Thanks again - Jake