Hi,
I am trying to calculate the average of values returned by hlookup. The problem is that some of dataranges have columns with blank cells. For some reason excel counts those blank cells and skews my average.
=AVERAGE(HLOOKUP(C3,data_range1,3,FALSE),(HLOOKUP(C3,data_range2,3,FALSE)),(HLOOKUP(C3,data_range3,3,FALSE)))
Please help me to figure out how to go about it w/o complicating too much.
Thx.
I am trying to calculate the average of values returned by hlookup. The problem is that some of dataranges have columns with blank cells. For some reason excel counts those blank cells and skews my average.
=AVERAGE(HLOOKUP(C3,data_range1,3,FALSE),(HLOOKUP(C3,data_range2,3,FALSE)),(HLOOKUP(C3,data_range3,3,FALSE)))
Please help me to figure out how to go about it w/o complicating too much.
Thx.