Thank you very, very much mrgoldthorpe. I had made an elementary mistake in my calculations as I had wrote =SUM(INDIRECT(C1:C6)) which was not obviously working.
Hi
A really basic Excel question:
I have a complicated sheet with a lot of data and calculations. A function extracts from the data a position where certain rules are fulfilled. The output of the function is in first cell the address where these rules were OK first time and in second cell the...