Hi Folks
I'm after some advice please
=SUMIFS(Paste_Sheet!$F:$F,Paste_Sheet!$N:$N,$C11:$C200,Paste_Sheet!$C:$C,$C$2:$C$8,Paste_Sheet!$D:$D,D$1)
$F:$F = Is the range to be summed
Paste_Sheet!$N:$N,$C11:$C200 = The event name to be matched against
Paste_Sheet!$C:$C,$C$2:$C$8 = The questions asked
Paste_Sheet!$D:$D,D$1 = The options available for each question asked. This runs from D$1 through to M$1
What I'm trying to achieve is that the column F:F is to be totalled for each option on each question, dependant on the event.
For example
The question. "The content is Relevant to me" has 5 possible responses:
Strongly Agree
Agree
Neutral
Disagree
Strongly Disagree
If an event named Event One is listed in column N:N then the formula would return the number of responses shown in F:F for each of the possible options.
EG If 3 people selected Agree and 2 selected Neutral, then that is what it would return
Can anyone look at my attempt please and give some advice?
Kind regards
DezB