Adding the amount of specific contacts across 3 different sheets and averaging based on network days
I am wondering if it is possible to combine a VLOOKUP formula with a COUNTIF in order add unique contacts in a single select contact column used in 3 different sheets and then find the average within the given network days. For example, I have 3 columns on 3 sheets that are named "Quality Inspector", "QC Inspector", and "Inspector", each of these columns are single select contact columns with common names between each one of them. I am looking to add these contacts between the 3 sheets and then find the average within the given number of network days. And ultimately display this average number onto a current metric sheet. Current formula shown below where I am able to average inspections based solely on 1 sheet, I am hoping it is possible to do this across 3 different sheets.
Thank you for any and all help.
Help Article Resources
Check out the Formula Handbook template!