her formulas from columin Q back to column J she noticed a "AREF" error in cells Jfyla. "In your response, ideacify as beit you can what has fuppened here. Winy is there a division happening? Whece do you think the 0 came from that the function is irying to divide by? 3. Saby hes no idea what the deal is with column Q containing the 'aer'. error In vour response, figure it out and identity what happened in your file, fix it calculate the max value: In your response, Identify as best you can what happened, In your file, fix it. what's non-applicable' In your response, identify as best you can wtat happened. (You do not need to foxit, nor do you need to be able to fully parie the viookup function - Weli get to its technical details in times In your respogse, identify as best rou can what hapenet. Vou do not need to hxit, nor do you need to be able to fully parse the viookup function- we?t get to lits techrical details in tique *iverleich Morton. something else In your response, ideneify as best you can what happened here and why the functoon is trying to divide by zero again. 9. See if you can do any better, Use a SUMIF function matching en the date for each dxy of this past week and eoter a formula in celi M14, then copied down through to M20, to calculate the dally total sales (from coluenn H across all tramoctions on each day of the week. Review View Automate Help