range offset

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
I managed ..

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

Regards
Mark
 
Mark said:
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
Click to expand...

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