起迄日天數平分數值 計算各月總和 (14953)

G3:L6{=SUM(TEXT((IF(EOMONTH("1-"&G$2,0)-$C$3:$C$22>=0,$C$3:$C$22,EOMONTH("1-"&G$2,0))-IF(("1-"&G$2)-$B$3:$B$22<=0,$B$3:$B$22,("1-"&G$2)*1)+1)*($A$3:$A$22=$F3),"0;!0;0")*($D$3:$D$22/($C$3:$C$22-$B$3:$B$22+1)))