Indirect Issue

Hi all,

I have a problem where im trying to use indirect in a formula.

Please Login or Register  to view this content.

This is copying across the page well but I am having to adjust the formula a lot to respresent new columns

for example I want to adjust the C to an E - I have tried using indirect to keep the E in lets say B5

Ive tried to use

Please Login or Register  to view this content.

I know this is an issue with the parenthases but im not sure why, please can you help me out with this..

Thanks Rup

This is great thanks for your help.