Hi,
I'd like to sum the content of the cells A1:??, where ?? can vary. Actually, ?? is defined another cell, let's say B1 (i.e. the argument of B1 is A10), how do I include in SUM(A1:??) the content of the cell B1, and not B1 itself?
thanks and regards
Mauri
use indirect
so SUM(INDRIECT("A1:"&B1))
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
One way...Originally Posted by mauz81
=SUM(A1:INDIRECT(B1))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
How about
=SUM($A$1:INDIRECT(B1))
HTH
Regards, Jeff
Non-volatile alternative:
=SUM(A1:INDEX(A:A,MID(B1,2,100)))
Regarding to Cutter solution I assume you defined A10 as a criteria. But you could enter just 10 in B1 and use:
=SUM(A1:INDEX(A:A, B1))
Never use Merged Cells in Excel
thanks to all of you, your solution are all valuable.
You're welcome. Thanks for the 'star tap'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks