We have three clients who use a tracking workbook that we have created which have formulas that are not calculating. Most of the workbook is calculating - I've noticed the cells that are not are averaging data from several month sheets.
These are new clients who have not filled out previous months - I think that's the problem. Here is my formula (on the May page): =IFERROR(AVERAGE(Jan!K34,Feb!H34,March!H34,April!H34,H34),"")
If I go in and manually enter data for K34 & H34 for each month then the cell does calculate. So, it thinks there is an error which is why it won't calculate.
What can I do to fix this? Thank you in advance!
Bookmarks