Formula for adding up columns, i.e., B1:B10 + D1:D10 + F1:F10 + H1:H10 + J1:J10

[StargateFanFromWork]

I've never figured this one out. Went and googled yet again but I'm
obviously not googling for the right thing. Same as with the help file.
What is the type of formula we use for adding up columns or rows, esp. if
they're broken up by rows/columns in between?

Thanks!

 

[Peo Sjoblom]

=SUM(B1:B10,D110,F1:F10,H1:H10)

 

[StargateFanFromWork]

=SUM(B1:B10,D110,F1:F10,H1:H10)

A COMMA!! A @#$#@ comma is what has held me up all this time <lol>. I
should have asked a lot sooner!

Thanks so much! It's always the little things that stump us. Do I ever
feel silly. D

 

[Dave Peterson]

Sometimes, if you let excel help, you'll have less to remember.

Type:
=sum(
point at the first range (b1:B10)
then ctrl-click and point at the subsequent (D1:d10 and so forth).

Then take a look at your formula.

 

[StargateFanFromWork]

Thanks for the tip.

I had tried that but it didn't work. I'm guessing I did something wrong.

Thanks.

 

[Dave Peterson]

I would guess that same thing -- 'cause it worked ok for me.

 

[StargateFanFromWork]

Ah, it's the ctrl-click that does it. It wasn't working because I didn't
have that linking keystroke. Thanks for the tip!

 

[Dave Peterson]

Glad it worked for you.

Ah, it's the ctrl-click that does it. It wasn't working because I didn't
have that linking keystroke. Thanks for the tip!