welcome to the forum, Renee. you could do it like this:
=SUM(INDIRECT(ADDRESS(N33,10)&":"&ADDRESS(O33,10)))
but INDIRECT is volatile & will slow down your workbook. so this might be better:
=SUM(INDEX(J:J,N33):INDEX(J:J,O33))
change my commas to semi-colons for it to work on your regional settings
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you benishiryo ! Great ! It works exactly the way I need ... and I tried so many ways but not INDIRECT or INDEX;
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ReneeL 
Register To Reply
Bookmarks