二数字間 數據求和 (9454)

D2{=SUM(IFERROR((B2:B8>=10)*(B2:B8<=20)*B2:B8,))

另解=SUMIFS(B:B,B:B,">=10",B:B,"<=20")

另解=SUMPRODUCT(TEXT(B2:B8,"[<10]!0;[>20]!0;0%;!0")*1)