帮我解析一下这些公式

一直很低调

SUM(TEXT(I5+5-COLUMN(3:3)*5,"0;!0")*0.03)

=SUMIF(H5,">0")+SUMIF(Y5,">0")+SUMIF(AF5,">0")+SUMIF(AI5,">0")

=SUMIF(H5,"<0")+SUMIF(Y5,"<0")+SUMIF(AF5,"<0")+SUMIF(AI5,"<0")

这些公式什么意思啊？

dajiahaoxinku12

SUM(TEXT(I5+5-COLUMN(3:3)*5,"0;!0")*0.03)

i5的值+5-（很多5的倍数，5,10,15,20…………1280） 所得出的值有正有负，正的等于本身，负的都等于0
然后求和后再乘0.03


=SUMIF(H5,">0")+SUMIF(Y5,">0")+SUMIF(AF5,">0")+SUMIF(AI5,">0") ，四个单元格的值相加，每个单元格里的值必须是>0才能加在一起，不大于0的视同为0