Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

OFFSET NOT WORKING

=OFFSET('D2 Data'!$DW$2,0,0,COUNT('D2 Data'!$DW:$DW),8)

I have this offset formula, but its returning a ref error

Can anyone see why?

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
barry houdiniCommented:
Hello Seamus,

You might get #REF! error if the COUNT formula resolves to zero

What do you get if you put this formula in a cell on the worksheet?

=COUNT('D2 Data'!$DW:$DW)

COUNT only counts numbers - if the data in column DW is text then use COUNTA instead (that counts text and numbers)

regards, barry
0
 
Seamus2626Author Commented:
Perfect, thanks Barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now