Hi Team,
I'm having a (what I think) very simple SUM issue, but it's a Monday and I can't work it out!
Effectively, I am trying to do a COUNTIF and SUM in one. My COUNTIF is as follows (and works, no issues there):
=SUM(COUNTIF(INDEX(Data!$F:$AO,,A2),"Strongly Agree"))+(COUNTIF(INDEX(Data!$F:$AO,,A2),"Agree"))+COUNTIF(INDEX(Data!$F:$AO,,B2),"Strongly Agree")+(COUNTIF(INDEX(Data!$F:$AO,,B2),"Agree"))+COUNTIF(INDEX(Data!$F:$AO,,C2),"Strongly Agree")+(COUNTIF(INDEX(Data!$F:$AO,,C2),"Agree"))
Essentially, I want to divide this by three, but when I add "/3" to the end, it only divides the last sum by 3. What am I missing?
Thanking you in advance.
I'm having a (what I think) very simple SUM issue, but it's a Monday and I can't work it out!
Effectively, I am trying to do a COUNTIF and SUM in one. My COUNTIF is as follows (and works, no issues there):
=SUM(COUNTIF(INDEX(Data!$F:$AO,,A2),"Strongly Agree"))+(COUNTIF(INDEX(Data!$F:$AO,,A2),"Agree"))+COUNTIF(INDEX(Data!$F:$AO,,B2),"Strongly Agree")+(COUNTIF(INDEX(Data!$F:$AO,,B2),"Agree"))+COUNTIF(INDEX(Data!$F:$AO,,C2),"Strongly Agree")+(COUNTIF(INDEX(Data!$F:$AO,,C2),"Agree"))
Essentially, I want to divide this by three, but when I add "/3" to the end, it only divides the last sum by 3. What am I missing?
Thanking you in advance.