Can anyone help with this formula?
I'm using in a sheet summary and it keeps returning #unparsable.
=SUMIFS([% Complete], [Task Type], "contract award") / SUMIFS([Duration], [Task Type], "contract award")
I'm trying to calculate the total % Complete as a percentage of the total duration for a specific task type.
Thanks
Cara
Best Answer
-
Hey @carak,
If you're trying to have the formula search a whole column, you have to have the column range entered like this:
[% Complete]:[% Complete], [Task Type]:[Task Type], Duration:Duration
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
Answers
-
Hey @carak,
If you're trying to have the formula search a whole column, you have to have the column range entered like this:
[% Complete]:[% Complete], [Task Type]:[Task Type], Duration:Duration
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
Thanks bisaacs, that worked :)
Help Article Resources
Categories
Check out the Formula Handbook template!