- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Sheet References in a formula

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

- RE: Sheet References in a formula posted by Randy Hunt on Tue, 28 Oct 2003
- Re: Sheet References in a formula posted by J.E. McGimpsey on Tue, 28 Oct 2003
- RE: Sheet References in a formula posted by Randy Hunt on Tue, 28 Oct 2003