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,