Hi All,
I have been struggling to find a solution on how to get a Sumif formula to work. Essentially, I want to Sum if a cell contains a specific name, however the name column is multiselect and can have multiple people in it. I have tried both the HAS and CONTAINS formulas but haven't been able to get one to work.
The cells in the formula are also being linked from another sheet.
My current formula is: =SUMIFS({Projects Names}, HAS(@Cell, "Name"), {Projects Hours}). The error I get there is UNPARSEABLE. What am I missing here? This has been the solution I have seen on different threads but it doesn't seem to work for me.
Thank in advance 😀