I have a bunch of named ranges with this formula to change the range length when the data changes. Occasionally at the end of the data I will get a rows of #N/A if the data query does not pull any data for the entire data range.

How can I change this formula =OFFSET('Misc Calculations'!$T$9,0,0,COUNTA('Misc Calculations'!$T:$T)-1) to exclude the #N/A in the rows? When it includes it my graphs get all messed up because it includes this data on the graph.


Thank you,