Thanks Tony, good to know I was approaching it right. Still wish there was a way for Excel to intelligently ignore data outside of your dataset but I guess that is asking too much (there are probably few reasons why someone would want to include all blank cells up to Excel's limit in their formulas lol)