Convert Text string to Array Formula

  • Thread starter Thread starter Steve Schlesinger
  • Start date Start date
S

Steve Schlesinger

I have numerical data in A1:A10

B1 has a string "A2:A6"

I want to convert the string to an array formula so that
=SUM( some forumla with B1 ) returns the same as
=SUM( A2:A6 )

A solution with VBA is OK.

Thanks-
Steve AT Schlesinger DOT com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Query 9
Convert text into formula. 7
Is there an array formula that works with text? 3
Dynamic Sum Array Formula Input Help 3
Array Problem 4
sum vlookup results 5
Array reference 1
rolling weeks formula 4

Back
Top