Trying to get an Avg $/Hr with a specific task type, Date range, & assigned to.
=AVG(COLLECT({SOS - $/Hr}, {SOS Task Type}, =[Task Type]7, {SOS Project Closed}, >[Start Range]1, {SOS Project Closed}, <[End Range]1, {SOS Assigned to}, =[Assigned To]2)) Gives #INCORRECT ARGUMENT SET.
Using AVERAGEIF is #UNPARSEABLE
Thanks for any help
Answers
-
If that error is not present in any range referenced, double check that your ranges are all single column selections from the same sheet as each other.
-
Not sure what is different today. No change to my statement but it works today when it gave an error yesterday. Any thoughts why? But info is populating as needed.
-
It sounds like maybe there was just some latent data on the back end that was hanging on for longer than it should have.
Glad it is working for you now though.
Help Article Resources
Categories
Check out the Formula Handbook template!