locked
Sum upto a certain row index number RRS feed

  • Question

  • QUESTION RELATED TO CONDITIONAL SUMMING

    If I put row index as a certain no. then it should add upto that row and it should display also upto that row.

    Kindly help me with this..

    Thursday, March 3, 2016 4:51 AM

Answers

  • >>>QUESTION RELATED TO CONDITIONAL SUMMING

     If I put row index as a certain no. then it should add upto that row and it should display also upto that row.<<<

    According to your description, since there is less information about your issue, I suggest that you could provide more information about your issue, do you want to achieve your requirement

    manually or programmatically? That will help us resolve your issue.

    In addition if you do it manually, you could sum a range of values within a table using the INDEX function in Excel like this:  =SUM(INDEX(Array, Row_Num, Column_Num))

    or post your question to the Technet forum for Excel IT Pro Discussions

    https://social.technet.microsoft.com/Forums/office/en-US/home?forum=Excel

    For more information, click here to refer about INDEX function

    Thanks for your understanding.

    • Marked as answer by David_JunFeng Sunday, March 13, 2016 1:12 PM
    Friday, March 4, 2016 4:54 AM

All replies

  • Hi shanky169,

    If your issue is in Excel file (workbook, Function, VBA), could you share your file via cloud storage such as OneDrive, Dropbox, etc?  I'd like to see your problem in front of me.

    Regards.
    ___________________
    Hideki Ashida

    Thursday, March 3, 2016 11:08 AM
  • >>>QUESTION RELATED TO CONDITIONAL SUMMING

     If I put row index as a certain no. then it should add upto that row and it should display also upto that row.<<<

    According to your description, since there is less information about your issue, I suggest that you could provide more information about your issue, do you want to achieve your requirement

    manually or programmatically? That will help us resolve your issue.

    In addition if you do it manually, you could sum a range of values within a table using the INDEX function in Excel like this:  =SUM(INDEX(Array, Row_Num, Column_Num))

    or post your question to the Technet forum for Excel IT Pro Discussions

    https://social.technet.microsoft.com/Forums/office/en-US/home?forum=Excel

    For more information, click here to refer about INDEX function

    Thanks for your understanding.

    • Marked as answer by David_JunFeng Sunday, March 13, 2016 1:12 PM
    Friday, March 4, 2016 4:54 AM