SUMIF formula help
Answers
-
Hi
Hoping someone can help!
As we don't have the Resource Management add on I'm trying to calculate the number of days assigned to each person in the project plan, however some "Assigned To" cells contains multiple names.
I have tried to use the above formula provide by Parul Mishra
=SUMIF({PROJECT PLAN: CERIDIAN DAYFORCE Range 2}, CONTAINS("Jack Jones", @cell), {PROJECT PLAN: CERIDIAN DAYFORCE Range 3})
(Range 2 is "Assigned To" column, Range 3 is "Duration" column)
But the formula is either returning 0 or 1, even though I know that Jack Jones has multiple days.
Any help would be much appreciated.
Many thanks
JW
(PS not sure what the @cell part of the CONTAINS formula is referring to)
-
Hey @Jacqué Whitlock
To answer the @cell question. This tells the function 'CONTAINS' to look at each cell, one by one, in your range {PROJECT PLAN: CERIDIAN DAYFORCE Range 2} and see if it contains "Jack Jones".
When using a multiselect column, you have three functions that can help see the individual responses within the cell. These are CONTAINS, HAS and FIND.
Try this
=SUMIF({PROJECT PLAN: CERIDIAN DAYFORCE Range 2}, HAS(@cell,"Jack Jones"), {PROJECT PLAN: CERIDIAN DAYFORCE Range 3})
Does this work for you?
Kelly
-
That work's perfectly thank you Kelly, very much appreciated 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!