Excel Offset Function Dynamic Range Question

Specifically, it looks like D53 is blank
Therefor it is not counted in the COUNT function which is used in the dynamic range to determine how many columns are included in the range.

Originally Posted by Jonmo1

Specifically, it looks like D53 is blank
Therefor it is not counted in the COUNT function which is used in the dynamic range to determine how many columns are included in the range.

You're right. When I put a 0 in D53 the formula corrected itself and the range now includes Column K. Thanks!
What I don't get however, is in other rows I have empty cells but it never affected the formula before?

You're welcome...

Originally Posted by d247

What I don't get however, is in other rows I have empty cells but it never affected the formula before?

Can you show an example of that?

My mistake - I just reviewed the row I thought was not being affected by the empty cell but it is being affected I just didn't notice.
So the answer was to change all empty cells to a 0 - Thank you both!