Excel: show the row when either one of the columns is>0

[vicki]

Dear freinds:

I have the worksheet below:

Name Jan Feb Mar Apr May Jun---Dec
John 1 0 5 4 0 0
Mary 0 0 0 0 0 0
Peter 2 0 0 1 0 0

is it the report can be shown automaticall that: only to show the name when
either from Jan to Dec the figure is>0
since this worksheet data are the data referred from another worksheet, so I
cannot just hide the row "Mary", as Mary may have/have not figures is >0
during Jul - Dec

thanks in advance for all your help

 

[JBeaucaire]

Assume that layout is at the top of the page, whatever formula is in the cell
A2 to make John's name appear, use this:

=IF(SUM(B2:M2)=0,"","John")

....and replace the "John" part with the existing function you're using.

 

[vicki]

Dear JB,

it works, many thanks for your help. : -)