working with array

[jamesjessie117]

Trying to get the sum of all the survey of the customer (to be placed on B10, B11, B12) based on their score in Worksheet Data. After that It would match the result of B10 to B7, B11 to C7 and B12 toD7. If they match it would provide a result of Correct if not Incorrect (to be placed on C10, C11, C12 respectively).



Thanks

[NBVC]

Try in B10:B12

=SUM(COUNTIF(Data!$B$2:$B$21,{"9","10*"}))

=SUM(COUNTIF(Data!$B$2:$B$21,{"7","8"}))

=SUM(COUNTIF(Data!$B$2:$B$21,{"0*","6"}))

Then in C10:C12

=IF(B10=B7,"Correct","Incorrect")

=IF(B11=C7,"Correct","Incorrect")

=IF(B12=D7,"Correct","Incorrect")

[WorldBridge]

Here is what I came up with for B10:B12

=SUM(IF(Data!B2:B21=10,1,IF(Data!B2:B21=9,1,0)))
=SUM(IF(Data!B2:B22=8,1,IF(Data!B2:B22=7,1,0)))
=SUM(IF(Data!B2:B21<=6,1,0))

You need to make each cell an array formula so hit cntrl+shift+enter to leave the cell

My C10:C12 were the same as NBVC