Thread: Sum of two offset cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Craig Craig is offline
external usenet poster
  
Posts: 208
Default 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
Reply With QuoteReply With Quote