Variable ranges
 

Hi,

I seem to have become a bit lost, hoping you guys can help, I am wanting to
replace a number of array formulas.

Example:

=SUM(IF((DUDListData!$T$2:$T$65536=DUDListData!$Y$ 1)*(DUDListData!$U$2:$U$65536=Summary!$G$2)=1,1,0) )/SUM(IF(DUDListData!$U$2:$U$65536=Summary!$G$2,1,0) )

I thought these were great idea, and they work great, but I understand I
should be using the offset and indirect functions to declare the ranges.

Is this correct? If so could someone give me a start to work on please. My
mind has gone blank on this one as I have never used these functions before.

Many thanks in advance


John

See your later post.

Biff

"John Contact" wrote in message
...
Hi,

I seem to have become a bit lost, hoping you guys can help, I am wanting
to
replace a number of array formulas.

Example:

=SUM(IF((DUDListData!$T$2:$T$65536=DUDListData!$Y$ 1)*(DUDListData!$U$2:$U$65536=Summary!$G$2)=1,1,0) )/SUM(IF(DUDListData!$U$2:$U$65536=Summary!$G$2,1,0) )

I thought these were great idea, and they work great, but I understand I
should be using the offset and indirect functions to declare the ranges.

Is this correct? If so could someone give me a start to work on please. My
mind has gone blank on this one as I have never used these functions
before.

Many thanks in advance


John