use CAPS
start with =
followed by (
a group of adjacent cells uses a :
a group op non-adjacent cells uses a ;
end your range witha a )
=(B1:B8) the range B1 till B8. this means all cells between cel B1 en B8 including B1 en B8
=B1;B8 this means cell B1 andB8
=(B1:B8);(C3:C6) the range B1 till B8 and the range C3 till C6