I am getting the #value error because it cannot ignore text - how do I update my formula so that it will ignore text:
=(AVERAGE(HLOOKUP(TODAY(),'Exit Criteria Trend (daily)'!1:11,9,FALSE),HLOOKUP(TODAY(),'Exit Criteria Trend (daily)'!1:11,10,FALSE), HLOOKUP(TODAY(),'Exit Criteria Trend (daily)'!1:11,11,FALSE)))-(AVERAGE(HLOOKUP(WORKDAY(TODAY(),-1),'Exit Criteria Trend (daily)'!1:11,9,FALSE),HLOOKUP(WORKDAY(TODAY(),-1),'Exit Criteria Trend (daily)'!1:11,10,FALSE), HLOOKUP(WORKDAY(TODAY(),-1),'Exit Criteria Trend (daily)'!1:11,11,FALSE)))
=(AVERAGE(HLOOKUP(TODAY(),'Exit Criteria Trend (daily)'!1:11,9,FALSE),HLOOKUP(TODAY(),'Exit Criteria Trend (daily)'!1:11,10,FALSE), HLOOKUP(TODAY(),'Exit Criteria Trend (daily)'!1:11,11,FALSE)))-(AVERAGE(HLOOKUP(WORKDAY(TODAY(),-1),'Exit Criteria Trend (daily)'!1:11,9,FALSE),HLOOKUP(WORKDAY(TODAY(),-1),'Exit Criteria Trend (daily)'!1:11,10,FALSE), HLOOKUP(WORKDAY(TODAY(),-1),'Exit Criteria Trend (daily)'!1:11,11,FALSE)))