麻烦按季度求出王五的工资。谢谢

sandays

=SUM(VLOOKUP($A11,$A$3:$M$7,(COLUMN(A1)-1)*3+{2,3,4},0))

mjm04

偷个鸡

B3单元格

=TRANSPOSE(BYROW(WRAPROWS(FILTER($B$3:$M$7,$A$3:$A$7=A11),3),SUM))

mengrs

=SUMPRODUCT(($A3:$A7=$A11)*(LEN(2^SUBSTITUTE($B2:$M2,"月",))=COLUMN()-1)*$B3:$M7)

xtmyd5156

有规律
=BYCOL(WRAPCOLS(FILTER(B3:M7,A3:A7=A11),3),SUM)

mykitami

=SUM(FILTER(OFFSET($B$2:$M$2,MATCH($A11,$A$3:$A$7,),),ROUNDUP(LEFTB($B$2:$M$2,2)/3,0)=FIND(MID(B$10,2,1),"一二三四")))

沈默00

=SUM(($A$3:$A$7=$A$11)*((CEILING(LEFT($B$2:$M$2,FIND("月",$B$2:$M$2)-1)/3,1)=COLUMN()-1)*$B$3:$M$7))  右拉

叶子cz

=SUM(VLOOKUP($A11,$A$2:$N$7,MATCH(FILTER($I$10:$K$13,$H$10:$H$13=B$10),$A$2:$N$2,0)))

A九月

叶子cz 发表于 2025-3-24 13:30
=SUM(VLOOKUP($A11,$A$2:$N$7,MATCH(FILTER($I$10:$K$13,$H$10:$H$13=B$10),$A$2:$N$2,0)))