I am trying to get the average TAT of reports. There are three sheets in this workbook: January, Admin and Summary. January is what the historians manually fill up, Admin is for evaluation purposes (I've used Vlookup to fill in the data) and the Summary is where I wish to place the formula I am having issues with.
This is my formula =AVERAGEIFS(Admin!M:M,Admin!N:N,"AHMG",Admin!O:O,">= 01/01/2014",Admin!O:O,"<=01/31/2014")
However, since the values in Admin sheet are all vlookup values and not actual data, I can't make it work. Any idea on how to make this work?
Thank you so much!
Bookmarks