Dear JB,

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


"JBeaucaire" wrote:

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.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"vicki" wrote:

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

only to show the name when either from Jan to Dec the figure is0
since this worksheet data are the data referred from another worksheet,