Question

What will be the result of the formula = Average (B1: B3)? Where B1 = 5, B2 = 4, B3 = 6?​

Answer 1

Explanation:

=SUM(B1,B2,B3) = 8

=SUM(B1:B2) = 5

=SUM(B1,B2) = 5

=SUM(B1,B2,B3,B5) = 8

=SUM(B1:B5,"0") = 8

=SUM(LEN(B1),LEN(B4)) = 10

=SUM(1/COUNTIF(B1:B3,"<10")) = 0.33

=SUM(IF(B1:B3>=20,IF(B1:B3<=100,B1:B3,0),0)) = 0

{=SUM(LEN(B6:B7))} = 8

=SUM(LEN("some text")) = 9

=SUM(1,2,"some text") = #VALUE!

=SUM(B1:B5,"") = #VALUE!

=SUM(LEN(B6:B7)) = #VALUE!

{=SUM({1,2}*{3,4})} = 11

{=SUM({1,2,3,4}^2)} = 30

=SUM(IF(B1:B3>=20,IF(B1:B3<=100,1,0),0)) = 0

=SUM({10,20,30}) = 60

=SUM(10,20,30) = 60

=SUM(B1:B3,15) = 23

=SUM("3","2",B3) = 8