Hi. This is a basic problem but I'm having trouble with it. I want to create a sumif but my knowledge of the filter function isn't that great so I keep running into some dumb error. Here is the formula as I understand it.
Sum(Filter(Data1,Multipack = "Yes").Units)
The error is "expected a text value". This doesn't make sense to me as multipack is a text field and "Yes" is a text value. I've run into issues like this in the past so an explanation of the error and what it means would be really helpful for me to avoid it in the future. Thank you.