I have a formula that uses cells D2:D20, the problem is the info that it is
using is updated through a query, so I might need the range to be D2:D30, if
I set the range to larger than what i need it causes an error in the formula,
is there a way to make excel recognize whether there is a value in the cell
or not and include it in the formula range so the formula range floats with
the data that arrives through the query.

Thanks