sum if and match range of cells in
Hello, I am trying to sum rows in a column if a text in 1 column matches text in a range in another column. And have that number show up in a Summary field.
If we look at the sheet, I want to sum values in the "# of Views" column if the data in "Workspace Title" match a range of cells in the Workspace column. So the formula would look at row 2 and 30, see that both term sin Workspace Title column match the children under "Professional Skills Development. So therefor return 16 in the Summary field PSD.
I have tried sum , sumifs, sum(collect. But I just can't figure it out. The best I can do is =SUMIF([Workspace Title]:[Workspace Title], HAS(@cell, Workspace2:Workspace30), [# of Views]:[# of Views]). I get a return of 0.
Help Article Resources
Check out the Formula Handbook template!