I’m trying to create an excel column where it only includes responses from participants of a certain age and employment for the purchase probability, I’ve inputted the code but keep getting VALUE, what am I doing wrong???

My code is =AVERAGEIFS(Intent (sum of probabilities per response times 100), employment data, employment data response I want included (3 full time worker), age response data, age response that I want included)

What am I doing wrong???

The question I’m trying to answer states, “For the question, include only responses from respondents who have an EMP value of 3, and are between 26 and 35 (3).

Using purchase probabilities of 0%, 8%, 16%? 36% and 63% for purchase intent (INTENT) responses of 1,2,3,4,5, respectively, what is the average purchase probability for concept 2?”

I’ve already modified the data so it’s percent of responses times the probability amount given times 100, so what else could I be doing wrong?