How do I enter a formula using semi-selection?

Question

In cell C7, enter a formula using semi-selection to add cells C4, C5 , C6

Answer 1

Marques, Here are two somewhat different ways to do it: ( In what follows, type everything but the quote marks (“) )

1) using individual cells:

1. into C7, type “=Sum(“
2. click in C4, (this will append “C4” in C7)
3. type “,”
4. click in C5
5. type “,”
6. click in C6
7. type “)”

this creates a formula in C7 that reads

“=sum(c4,c5,c6)

2) using a range

1. in C7, type “=Sum(“
2. click in C4, and drag to C6 ( this will append “C4:C6” to C7)
3. type “)”

this creates a formula in C7 that reads

”=sum(C4:C6)

The first approach allows you to select cells that aren’t next to each other, while the second approach allows a shortcut, for when all the cells are contiguous.