[算表] GETPIVOTDATA 忽略不存在數質
軟體: Microsoft
版本: 2007
以下是我寫的東西:
SUM(
GETPIVOTDATA("Profit",Pivot!$A$3,"Type","AE","info.","Recurring","Month",H41),
GETPIVOTDATA("Profit",Pivot!$A$3,"Type","OE","info.","Recurring","Month",H41),
GETPIVOTDATA("Profit",Pivot!$A$3,"Type","OI","info.","Recurring","Month",H41)
)
是要從樞紐分析表中提取數值並加總 每個月分別有AE, OE, 跟OI
但每個月不一定有這三項數值
例: July AE=7, OE=3
June OE=5, OI=4
May AE=1, OE=2, OI=3
以上就會抓不到數值而顯示錯誤
所以請問要如何忽略不存在的數值
讓 July AE+OE+OI=7+3+0=10
June AE+OE+OI=0+5+4=9
May AE+OE+OI=1+2+3=6
謝謝
※ 編輯: silkworm 來自: 96.251.86.113 (07/27 08:55)
※ 編輯: silkworm 來自: 96.251.86.113 (07/27 08:57)
→
07/30 07:52, , 1F
07/30 07:52, 1F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
