TEXTJOIN with multiple criteria

Hello,

I am currently using this formula to join text, if the cells contain numbers (Using crtl, shift, enter)

{=TEXTJOIN(", ";TRUE;IF(ISNUMBER(VO3:VY3);(Colours!$I$2:$S$2);""))}

However, I'd like to add the criteria that the cells also do not contain zeroes. I would think the formula should look like this, but it will only give me blank returns.

{=TEXTJOIN(", ";TRUE;IF(AND(ISNUMBER(VO3:VY3);VO3:VY3<>0);(Colours!$I$2:$S$2);""))}

Any suggestions? Thank you!

Don't use AND in array formula as it will return only 1 value

Please try
=TEXTJOIN(", ";TRUE;IF(ISNUMBER(VO3:VY3)*(VO3:VY3<>0);Colours!$I$2:$S$2;""))