|Subject:||Sheet References in a formula|
|Posted by:||Randy Hunt|
|Date:||Tue, 28 Oct 2003|
I have the following formula that does exactly what I need - thanks to J.E. McGimpsey. =H48/INDEX (B8:K8,COUNTA (B8:K8)) *100. This works fine on the same sheet but now I need to work between sheets.
The H48 reference is on Sheet 2 and the B8:K8 range is on Sheet 1. How do I correctly insert the reference to Sheet 1 in this formula?