range offset

[Mark]

Hi,
Actually I have problem with offset (about 4 and 5
columns) defined range and count "txt" with value 1.
Why don't work below function?

=SUMPRODUCT((OFFSET(myrange,0,5,0,0)="txt")*(OFFSET
(myrange,0,4,0,0)=1)

I work in excel 2000 and myrange is in another sheet.

Regards
Mark

 

[Guest]

I managed ..

=SUMPRODUCT((OFFSET(myrange,0,5)="txt")*(OFFSET
(myrange,0,4)=1))

Regards
Mark

 

[Paul]

Hi,
Actually I have problem with offset (about 4 and 5
columns) defined range and count "txt" with value 1.
Why don't work below function?

=SUMPRODUCT((OFFSET(myrange,0,5,0,0)="txt")*(OFFSET
(myrange,0,4,0,0)=1)

I work in excel 2000 and myrange is in another sheet.

Regards
Mark

OFFSET(myrange,0,5,0,0) and OFFSET(myrange,0,4,0,0) are references to ranges
with zero height and width. The last 2 parameters should be 1 (or omitted).