葉育妤EXCEL名稱方塊,AND,OR,COUNT,COUNTIF,INDIRECT間接定址
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! FALSE FALSE #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! FALSE FALSE #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 25 FALSE =AND(ISNUMBER(T504),ISNUMBER(U504)) #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 29 FALSE =AND(ISNUMBER(T505),ISNUMBER(U505)) 6 3 6 4 0 32 118 0 3 範圍 S1:Y505 統計多少個數字 0 169 INDIRECT間接定址indirect Addrcssing 到X508儲存格找位址