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

  • Thread starter StargateFanFromWork
  • Start date
S

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!
 
S

StargateFanFromWork

Peo Sjoblom said:
=SUM(B1:B10,D1:D10,F1:F10,H1:H10)
Click to expand...

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. :eek:D
 
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.
 
S

StargateFanFromWork

Thanks for the tip.

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

Thanks.
 
S

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!
 
Top