Sum of two offset cells
 

Hi,

I'm having difficulty with this function.

=sum(offset(Sheet6!$B$47,(rows($1:1)-1)*47,0))+(offset(Sheet3!$B$47,rows($1:1)-1)*47,0)))

Can you tell me what I'm doing wrong?

Thanks

Sum of two offset cells
 

Try it like this:

=OFFSET(Sheet6!$B$47,(ROWS($1:1)-1)*47,0)+OFFSET(Sheet3!$B$47,(ROWS($1:1)-1)*47,0)

--
Biff
Microsoft Excel MVP


"Craig" wrote in message
...
Hi,

I'm having difficulty with this function.

=sum(offset(Sheet6!$B$47,(rows($1:1)-1)*47,0))+(offset(Sheet3!$B$47,rows($1:1)-1)*47,0)))

Can you tell me what I'm doing wrong?

Thanks

Sum of two offset cells
 

I could swear I tried that earlier and it wouldn't work, but it does now.
Thanks so much. Craig

"T. Valko" wrote:

Try it like this:

=OFFSET(Sheet6!$B$47,(ROWS($1:1)-1)*47,0)+OFFSET(Sheet3!$B$47,(ROWS($1:1)-1)*47,0)

--
Biff
Microsoft Excel MVP


"Craig" wrote in message
...
Hi,

I'm having difficulty with this function.

=sum(offset(Sheet6!$B$47,(rows($1:1)-1)*47,0))+(offset(Sheet3!$B$47,rows($1:1)-1)*47,0)))

Can you tell me what I'm doing wrong?

Thanks

Sum of two offset cells
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Craig" wrote in message
...
I could swear I tried that earlier and it wouldn't work, but it does now.
Thanks so much. Craig

"T. Valko" wrote:

Try it like this:

=OFFSET(Sheet6!$B$47,(ROWS($1:1)-1)*47,0)+OFFSET(Sheet3!$B$47,(ROWS($1:1)-1)*47,0)

--
Biff
Microsoft Excel MVP


"Craig" wrote in message
...
Hi,

I'm having difficulty with this function.

=sum(offset(Sheet6!$B$47,(rows($1:1)-1)*47,0))+(offset(Sheet3!$B$47,rows($1:1)-1)*47,0)))

Can you tell me what I'm doing wrong?

Thanks

Sum of two offset cells
 

Hi Craig

much better to avoid the volatile offset function altogether.
Try
=INDEX(Sheet6!$B:$B,47+ROWS($1:1)-1)*47)+INDEX(Sheet3!$B:$B,47+ROWS($1:1)-1)*47)
--
Regards
Roger Govier

"Craig" wrote in message
...
Hi,

I'm having difficulty with this function.

=sum(offset(Sheet6!$B$47,(rows($1:1)-1)*47,0))+(offset(Sheet3!$B$47,rows($1:1)-1)*47,0)))

Can you tell me what I'm doing wrong?

Thanks