Simple SUM

[BOZ12345]

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.

 

[Dave Patton]

Re: Simple SUM help

Enclose your formula with brackets and then add the /3

=(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")))/3

 

[BOZ12345]

Re: Simple SUM help

Thank you Dave, that is exactly what I needed on a Monday afternoon!

Cheers to you.