How to reference a specific line number in a sum formula

[limah82]

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

	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

 

[CA_Punit]

Try in this syntax =SUM(ZIR1_CHF:INDIRECT("ZIR1_OTH!N"&B4)),

I Suppose it should work

 

[gaz_chops]

It's not clear to me what you are actually trying to sum! Are you trying to sum multiple sheets for Cell N22?

 

[limah82]

Try in this syntax =SUM(ZIR1_CHF:INDIRECT("ZIR1_OTH!N"&B4)),

I Suppose it should work

hello, thanks for your help

unfortunately it does not work

 

[limah82]

It's not clear to me what you are actually trying to sum! Are you trying to sum multiple sheets for Cell N22?

Hello,

yes I want to sum multiple sheets for cell N22 but I want the "22" to be referrenced in a specific cell