LinkBack URL
About LinkBacks
Adding the numbers under a title and displaying the sum in front of the title
Adding the numbers under a title and displaying the sum in front of the title
Try this,
B1
=IF(ISNUMBER(A1),"",SUM(A2:INDIRECT("A"&IFERROR(AGGREGATE(15,3,ROW(A2:$A$100)/ISTEXT(A2:$A$100),1)-1,100))))
copied down.
Thank you very much, this solution solved my problem
You are welcome.
An alternative, avoiding the use of INDIRECT, which can cause performance issues, as it recalculates EVERY time anything is changed:
=IF(ISNUMBER(A1),"",SUM(A2:INDEX(A:A,AGGREGATE(15,6,ROW(A3:A17)/(ISERROR(1/(1/A3:A17))),1)-1)))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks