like mentioned earlier, start with an = sign then type in your formula then when you need your number input use a parenthesis ( then just drag the cells you want to include and put an end parenthesis ). so if your formula for ex is to multiply some cells by 3 i believe it would be =3*(a1:a7), if you cant figure the drag feature out, you can always manually enter the cells also using a colon in between them.