I have rows of data I'm trying to average, but am having trouble. I think there could be two problems.
1. Each cell is a vlookup function getting the data from elsewhere.
2. Some of the cells have no datapoint and instead display "#N/A".
I have data points in K38:N38, but O38 and P38 both show "#N/A". If I want to average K38:P38 how do I get a number back?
Thanks
1. Each cell is a vlookup function getting the data from elsewhere.
2. Some of the cells have no datapoint and instead display "#N/A".
I have data points in K38:N38, but O38 and P38 both show "#N/A". If I want to average K38:P38 how do I get a number back?
Thanks