I am trying to do an average to date over a quarter. I used =SUM(Jan:Mar!O2)/INDEX(FREQUENCY(Jan:Mar!O2,0),2) and it works fine as long as I have data in all three sheets. the cell I am pulling from as a formula and when no data is presented it show up as #DIV/0! what I want is for my quarter to date to show the average to date. so currently only Jan has data listed. any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
average quarter to date from 3 sheets
Similar threads
- Question
