[Excel] 胡德榮's Question
- 在B12至M12输入一月至十二月
- 在A13至A14输入112和113
- 在B13输入以下方程式,并拷贝B13粘贴到M14
- 完成
=SUMPRODUCT(($B$2:$M$9),($A$2:$A$9=$A13)*($B$1:$M$1=B$12))
Source: ---
Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.