• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumproduct from different sheet and range - may be impossible...


New Member
Dear Expert,

Go through the excel sheet.
I want to calculate cumulative days invested in investment but selling data and current investment data are in different sheet.

Now formula and answer if i keep it combine i have given in attached sheet and highlited in green color.

I want same formula in yellow highlighted cell if i keep the data in different site... i think its next to impossible but expert pl share your view..

Tushar M.