using variable from one cell as part of a formula cell reference in another cell?

**cravenm** · 11-05-2012, 12:22 PM

trying to create a counta formula using a variable referenced cell.

example
there may be 30 columns, normally you would say =COUNTA(B1:AD1)

in AH1 title how many columns in AH2 contains 24 this time (another user may change this to a different number say 15)

I want to be able to make the forumla COUNTA(B1:{get the reference cell based on what is in AH2, currently it has a value of 24 so I want it to use X1})

is it even possible to do this?
thanks for the help or any other ways to accomplish the same thing!!!

Michelle

**tigeravatar** · 11-05-2012, 12:43 PM

Michelle,

Welcome to the forum!
Give this a try:

Please Login or Register  to view this content.

**cravenm** · 11-05-2012, 01:18 PM

Hello tigeravatar,

Thank you very much for your quick response. It didn't quite give me what I wanted but it did give me something to get where I need to go with this. Thank you, Michelle

**tigeravatar** · 11-05-2012, 01:56 PM

You're welcome

For other visitors to this thread, can you please share your solution?

Also, if your question has been resolved, please mark this thread as solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**vlady** · 11-05-2012, 07:56 PM

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
For the meantime I'll do it for you.

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.

using variable from one cell as part of a formula cell reference in another cell?

LinkBack

Thread Tools

Rate This Thread

Display

using variable from one cell as part of a formula cell reference in another cell?

Re: using variable from one cell as part of a formula cell reference in another cell?

Re: using variable from one cell as part of a formula cell reference in another cell?

Re: using variable from one cell as part of a formula cell reference in another cell?

Re: using variable from one cell as part of a formula cell reference in another cell?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions