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.
Excel
Started by
SadiesMom
, Feb 22 2009 04:18 PM
#1
Posted 22 February 2009 - 04:18 PM
SadiesMom
-
- Member
-
- 8 posts
New Member
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.
#2
Posted 22 February 2009 - 04:53 PM
Vino Rosso
-
- Visiting Consultant
-
- 235 posts
Visiting Staff
How about =SUM($B$5:$B$500)
#3
Posted 22 February 2009 - 07:04 PM
SadiesMom
- Topic Starter
-
- Member
-
- 8 posts
New Member
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.
#4
Posted 23 February 2009 - 01:39 AM
Artellos
-
- Global Moderator
-
- 3,915 posts
Tech Secretary
Which version of Excel are you using? 
Regards,
Olrik
Regards,
Olrik
#5
Posted 23 February 2009 - 11:11 AM
Jonesey
-
- Member
-
- 335 posts
Member
Use this:
=SUM(INDIRECT("B5:B500"))
=SUM(INDIRECT("B5:B500"))
#6
Posted 23 February 2009 - 07:11 PM
SadiesMom
- Topic Starter
-
- Member
-
- 8 posts
New Member
Awesome. Thanks Jonesey, you saved the day It works perfectly. 
#7
Posted 24 February 2009 - 08:23 AM
Jonesey
-
- Member
-
- 335 posts
Member
No worries - glad it worked for you.
Similar Topics
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users
As Featured On:
Sign In
Create Account
