Sheet References in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I guess I should specify that the primary formula is located on sheet 2 along with H48. The difficulty is combining the sheet reference with the INDEX function?

----- Randy Hunt wrote: -----

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
 
I finally figured it out on my own. I'll post the solution in case it might help someone else.

H48/INDEX(Sheet 2!B8:K8,COUNTA(Sheet 2!B8:K8))*100

----- Randy Hunt wrote: -----

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
 
Back
Top