#Value! Error

[dbrhpln]

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)))

 

[Eric W]

Welcome to the MrExcel forum!

Try:

=(SUM(OFFSET('Exit Criteria Trend (daily)'!$A$9:$A$11,0,MATCH(TODAY(),'Exit Criteria Trend (daily)'!1:1,0)-1))-SUM(OFFSET('Exit Criteria Trend (daily)'!$A$9:$A$11,0,MATCH(WORKDAY(TODAY(),-1),'Exit Criteria Trend (daily)'!1:1,0)-1)))/3

 

[dbrhpln]

Thanks for the welcome and quick response! You are AWESOME - THANK YOU SO MUCH!!!!!!!

 

[Eric W]

Happy to help!