Dear All,
first of all thank you for spending some time reading this thread.
Description of my problem:
I have 1 summary sheet where i sum up the content of several other sheets (zir1_chf; zir1_eur;zir1_usd;zir1_oth), wich I do through sum of ranges, which is fine
The issue I have is that the sequence of lines on my summary does not follow the sequence of my source.
I have tried to nest the following formula but it does not work:
=SUM(INDIRECT("ZIR1_CHF:ZIR1_OTH!N"&CELL("contents";B4)))
thanks in advance for your help
first of all thank you for spending some time reading this thread.
Description of my problem:
I have 1 summary sheet where i sum up the content of several other sheets (zir1_chf; zir1_eur;zir1_usd;zir1_oth), wich I do through sum of ranges, which is fine
Column B | Column C | |
lines to be considered from data source | formula that works | |
Line 4 | 22 | =SUM(ZIR1_CHF:ZIR1_OTH!N22) |
Line 5 | 25 | =SUM(ZIR1_CHF:ZIR1_OTH!N25) |
The issue I have is that the sequence of lines on my summary does not follow the sequence of my source.
I have tried to nest the following formula but it does not work:
=SUM(INDIRECT("ZIR1_CHF:ZIR1_OTH!N"&CELL("contents";B4)))
thanks in advance for your help