Sheet References in a formula

Giganews Newsgroups
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?

Thanks.

RH

Replies