Overly cumbersome Excel formula

[JohnfromOH]

Is it possible to simplify this formula?

=IF((SUM(P27,T27,X27,AB27,AF27,AJ27,AN27,AR27,AV27,AZ27,BD27,BH27,BL27,BP27,BT27,BX27,CB27,CF27,CJ27,CN27,CR27,CV27)>0),SUM(P27,T27,X27,AB27,AF27,AJ27,AN27,AR27,AV27,AZ27,BD27,BH27,BL27,BP27,BT27,BX27,CB27,CF27,CJ27,CN27,CR27,CV27),"")

 

[tusharm]

If a zero value is acceptable just format it to look "invisible" (see Aladin's format suggestion in this discussion) Then, adapt what you were shown using the MOD() approach to get =SUMPRODUCT(--(MOD(COLUMN(O27:FO27)-COLUMN(O27),4)=0),--(O27:FO27>0))

Can this countif statement be simplified? Thanks to anyone who can help me.

 

[JohnfromOH]

Thanks Tusharm, Aladin and SHG. The suggestions work well.