Reformulate IF statement to count when higher than 0

Hey,

I currently use the following formula:

=(IF(AND(I1>0;J1>0;K1>0;L1>0;M1>0;N1>0);1;0))

My problem is that I can only know when all conditons are met = 1..

Is there a way to write it in order for it to display the number of cells above zero`

IE if 5 out of 6 are above zero, then display 5 (ideally without Helper column)

Thx!

Try

=COUNTIF(I1:N1;">0")

Thanks for the quick replies

Problem solved!

You're welcome.