問：如何算出區域中有多少個55?
答：CountIf(A1:D4,"=55") CountIf(A1:D4,55) COUNTIF(A1:D4,K2)
◆ A1:D4 哪幾個Cell有數字=Count(A1:D4)
◆ A1:D4 哪幾個Cell有資料=COUNTIF(A1:D4,"<>") =COUNTA(A1:B3)
◆ A1:D4 哪幾個Cell為空白=CountIf(A1:D4,"") =CountBlank(A1:B3)
DMCA Compliance - 內容侵犯 - Abuse 投訴