Hi! Thanks for replying. The only indication to avoid are the values being italicized. I am leaving an internship soon and my other employees have no VBA knowledge so I was trying to accomplish this without it. They will have to add data into a sheet of similar format and the formulas will most likely have to be edited because of this. I don't want the program to stop operating as soon as they do this because I will not be around to fix it.

I have also tried naming the data set excluding the empty and italicized cells and adding that to the formula instead but it gives back a value error. I am not sure if I am trying to do something that really isn't possible without VBA or if there is a better way to do this.