All,
I am using the below current formula in an attempt to get the Average Time to Fill for a specific range of numbers:
=SUM(M3+M8+42948)/+(N3+N8+358)
BUT what I really want to do is get the Average Time to Fill using the following data:
=SUM(QTR1_TA_TaleoData!U4:U170) PLUS the values from M3 and M8 located in the TA RAW DATA SUMMARY worksheet, then divide into =SUM(QTR1_TA_TaleoData!U4:U170) PLUS the value from N3 and N8 located in the TA RAW DATA SUMMARY worksheet. I want to do this without hardcoding a specific number as in the above example. Is this doable?
I am using the below current formula in an attempt to get the Average Time to Fill for a specific range of numbers:
=SUM(M3+M8+42948)/+(N3+N8+358)
BUT what I really want to do is get the Average Time to Fill using the following data:
=SUM(QTR1_TA_TaleoData!U4:U170) PLUS the values from M3 and M8 located in the TA RAW DATA SUMMARY worksheet, then divide into =SUM(QTR1_TA_TaleoData!U4:U170) PLUS the value from N3 and N8 located in the TA RAW DATA SUMMARY worksheet. I want to do this without hardcoding a specific number as in the above example. Is this doable?