Indirect Issue

[ruperupe]

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

[Haseeb Avarakkan]

Hi,

In B5 enter a column # instead of letter. eg: 3 for column C, 4 for column D, 5 for column E etc.... then use INDEX rather than INDIRECT which is a non volatile.

Please Login or Register  to view this content.

with CTRL+SHIFT+ENTER.

Since you are on XL 2007, you can use AVERAGEIFS. In C2 enter a date which you want to calculate avg. The below formula will calculate Avg in the full month entered in C2,

Please Login or Register  to view this content.

with just ENTER

[ruperupe]

This is great thanks for your help.