Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel


  • Please log in to reply

#1
SadiesMom

SadiesMom

    New Member

  • Member
  • Pip
  • 8 posts
I have a formula in cell c1 which adds all totals in b5 to b500.
At times I will be deleting rows in the b column.
How can I get the formula in c1 to ALWAYS add b5 to b500 even if I delete rows?

Thanking you in advance.
  • 0

Advertisements


#2
Vino Rosso

Vino Rosso

    Visiting Staff

  • Visiting Consultant
  • 235 posts
How about =SUM($B$5:$B$500)
  • 0

#3
SadiesMom

SadiesMom

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
I tried that, but as I delete rows it still changes to 499, 498, 497, 496 etc. I really thought the $'s would do it too, but no such luck.
  • 0

#4
Artellos

Artellos

    Tech Secretary

  • Global Moderator
  • 3,888 posts
Which version of Excel are you using? :)

Regards,
Olrik
  • 0

#5
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
Use this:

=SUM(INDIRECT("B5:B500"))
  • 0

#6
SadiesMom

SadiesMom

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
Awesome. Thanks Jonesey, you saved the day It works perfectly. :)
  • 0

#7
Jonesey

Jonesey

    Member

  • Member
  • PipPipPip
  • 335 posts
No worries - glad it worked for you.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP