Hi
i need to find the Average Time To Hire based on column K. I've tried to create an AverageIf but can't seem to get it to work.
The formular needs to find the average based on financial year (Col M), Status - Filled (Col J), Quarter (Col L) & All Region (Col E)
PLease can someone help
Thanks
Harry
Try in "B26"Formula:
Please Login or Register to view this content.
This is array formula : Ensure shift+ctrl+enter
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Hi Avk, thanks for this however i can't get it to work still. I have attached the actuall spreadsheet. The data is all hypothetical so no need to worry about data protection.
I need to fill row 32 on the on the summary tab. Everything i try seems to come back with an error.
Essentially i need to work out the average, by looking at Col J by "Filled" + Col K + Col E + Col P (Based on Financial year on summary tab) & Col O (Based on quarter on summary)
Thanks
Last edited by Harry Basra; 07-03-2017 at 05:21 AM.
maybe this one
formula is in C32 (cannot put in here, something with SUCURI went wrong)
see row 24 with years defined
and B25 with list defined
Last edited by sandy666; 07-03-2017 at 05:57 AM.
Try in "C32"
Formula:Please Login or Register to view this content.
Also small change in your formula "C27"
Formula:Please Login or Register to view this content.
Copy paste across
Last edited by avk; 07-03-2017 at 05:46 AM. Reason: addition
Thanks you very much all. Works perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks