[問題] excel 判斷為數字後加總
最近遇到一個難題懇求幫忙
資料如下
A欄 B欄
屬性 數值
甲 10
D1 15
B3 7
乙 8
C9 2
我想要把屬性那一欄裡所有不是中文字的數值加總
也就是D1 15 + B3 7 + C9 2 = 24
我的做法是先找出屬性裡最右邊一碼若為數字，就加起來
但單個儲存格判斷ok, 公式改為整欄連續判斷時卻不行
請教到底是哪邊出問題？？
sumif(A1:A5, isnumber(--right(A1:A5,1)),B1:B5)
應該是isnumber(--right(A1:A5,1))這邊不對
但要怎麼改實在摸不著頭緒
求板上大大幫忙
ps. 手機發文，希望排版不會亂掉
--
posted from bbs reader hybrid on my Sony C6902
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 223.138.219.29
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1460179373.A.C65.html
→
04/09 13:55, , 1F
04/09 13:55, 1F
→
04/09 22:40, , 2F
04/09 22:40, 2F
→
04/09 22:40, , 3F
04/09 22:40, 3F
→
04/09 22:51, , 4F
04/09 22:51, 4F
→
04/10 20:37, , 5F
04/10 20:37, 5F
→
04/10 20:59, , 6F
04/10 20:59, 6F
→
04/10 20:59, , 7F
04/10 20:59, 7F
→
04/10 21:23, , 8F
04/10 21:23, 8F
→
04/10 21:23, , 9F
04/10 21:23, 9F
→
04/10 21:31, , 10F
04/10 21:31, 10F
→
04/11 16:54, , 11F
04/11 16:54, 11F
→
04/11 16:54, , 12F
04/11 16:54, 12F
→
04/11 17:48, , 13F
04/11 17:48, 13F
→
04/11 17:48, , 14F
04/11 17:48, 14F
→
04/11 17:53, , 15F
04/11 17:53, 15F
→
04/11 17:57, , 16F
04/11 17:57, 16F
→
04/11 21:12, , 17F
04/11 21:12, 17F
→
04/11 21:12, , 18F
04/11 21:12, 18F
→
04/11 23:09, , 19F
04/11 23:09, 19F
→
04/11 23:52, , 20F
04/11 23:52, 20F
→
04/11 23:52, , 21F
04/11 23:52, 21F
→
04/11 23:52, , 22F
04/11 23:52, 22F
→
04/11 23:53, , 23F
04/11 23:53, 23F
→
04/12 00:12, , 24F
04/12 00:12, 24F
→
04/12 00:15, , 25F
04/12 00:15, 25F
→
04/12 19:39, , 26F
04/12 19:39, 26F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
