View Single Post
  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

One thought, one Comment/Question:

Thought:
I think you could simplify the formula a bit by using an array formula:
=AVERAGE(IF('Entire
Org'!$C$4:$C$4505&'EntireOrg'!$D$4:$D$4505&'Entire Org'!$E$4:$E$4505='Employee
Database'!$F1&'Employee Database'!$G1&'Employee Database'!$H1,'Entire
Org'!$I$4:$I$4505)).

Comment/Question:
The formula that you are asking to build will actually return a 4,401 item
array. The best you could hope to see would be one item in that array.
So...What is it that you are really looking to see from the formula?

Regards,
Ron