Quote Originally Posted by Jonmo1 View Post
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?