Spreadsheet: 67305d1267912157-array-cse-formula-problem-sampledata1
Sheet: Sheet1

 | sumif | -938.5 | correct
 | averageif | -10.20108695652174 | incorrect
 | Need to obtain correct average; approx 11.89
 | and correct countif of number values (excluding blanks and NA) approx 79
Colour | Num. | product | region
Blue | -6.3 | product h | US
Blue | NA | product g | US
Blue | NA | product g | US
Blue | -14 |  | Europe
Blue | -8.3 |  | US
Blue | -9.2 | product g | US
Blue | NA | product c | Europe
Blue | NA | product c | Europe
Blue | -12 | product d | Europe
Blue | -12 |  | Europe
Blue | -10 |  | US
Blue | 0 | product d | Europe
Blue |  | product g | Europe
Blue | 10 | product e | US
Blue | -25 | product e | US
Blue | -50 | product e | US
Blue | NA | product h | US
Blue | -2 | product a | US
Blue | -8.7 |  | US
Blue | -12 | product f | US
Blue | -35 | product f | US
Blue | -12 | product f | US
Blue | -12 | product f | US
Blue | -12 | product f | US
Blue | -12 | product f | US
Blue |  | product f | US
Blue | -17 |  | Europe
Blue | -17 | product c | Europe
Blue | -6 | product e | Europe
Blue | -30 | product b | Europe
Blue | -30 | product b | Europe
Blue | -40 | product e | Europe
Blue | -27 | product e | Europe
Blue | -22.5 |  | Europe
Blue | -28.3 |  | Europe
Blue | -22 |  | Europe
Blue | -7 | product g | Europe
Blue | -7 | product g | Europe
Blue | -27 | product g | Europe
Blue | NA | product f | US
Blue | NA | product f | US
Blue | -13 | product d | Europe
Blue | 0 | product b | Europe
Blue | -8 | product e | Europe
Blue |  | product g | US
Blue |  |  | US
Blue |  | product a | US
Blue | 0 | product a | US
Blue |  |  | US
Blue | -19 | product d | US
Blue | -22 | product g | US
Blue | -8 | product a | US
Blue | -8 |  | US
Blue | -6.2 | product a | US
Blue | -16 | product a | Europe
Blue | -16 |  | Europe
Blue | -12 |  | Europe
Blue | -12 |  | Europe
Blue | -15 | product g | Europe
Blue | -12 | product b | US
Blue | -13 | product b | US
Blue | -19 | product e | US
Blue |  | product b | Europe
Blue |  | product b | Europe
Blue | NA | product b | Europe
Blue | NA | product b | Europe
Blue |  | product b | Europe
Blue | -31 | product e | Europe
Blue | -23 | product e | Europe
Blue | 0 | product e | Europe
Blue | -20.8 |  | Europe
Blue | -50 |  | Europe
Blue | -9 | product f | US
Blue | NA | product f | US
Blue | -9 | product f | US
Blue | -4.8 | product f | US
Blue | -7 | product d | US
Blue | 0 | product e | Europe
Blue | -29 | product b | Europe
Blue | NA | product b | Europe
Blue | -11.3 | product f | US
Blue | NA | product f | US
Blue | 0 | product f | US
Blue | -16.2 | product e | US
Blue | -12.8 | product e | US
Blue | NA | product c | Europe
Blue | NA | product c | Europe
Blue | 0 | product a | Europe
Blue | 0 | product a | Europe
Blue |  |  | Europe
Blue | 0 |  | Europe
Blue |  |  | Europe
Blue | -10 | product b | Europe
Blue | -10 | product e | Europe
Blue | -33 | product h | Europe
Blue | -22.5 | product f | US
Blue | -11.3 |  | US
Blue | 0 | product g | Europe
Blue | -19 | product f | Europe
Blue | -6 | product e | Europe
Blue | NA | product g | Europe
Blue | NA | product g | Europe
Blue | -5 | product a | US
Blue | -9 | product a | US
Blue | -4.8 |  | US
Blue | 0 | product b | Europe
Blue | NA | product h | US
Blue | -8.8 | product h | Europe
Blue | -8.8 |  | Europe
Blue | 0 | product e | US
Blue |  | product g | US
Blue |  | product h | US
Blue | NA | product c | Europe
Blue | NA | product e | Europe
Blue | -9 | product b | US
Blue | -22.3 | product h | US
Blue | NA | product h | US
Blue | -21.7 |  | US
Blue | -16 | product d | US
Blue | -16 |  | US
Blue | -20 | product h | US
Blue | -9.3 | product e | US
Blue | -5.6 | product c | Europe
Blue |  | product c | Europe
Blue | 7.4 | product c | Europe
Blue |  | product c | Europe
Blue | -49 | product f | Europe
Blue | -19.8 | product c | Europe
Blue | -15.6 | product c | Europe
Blue | -15.3 | product g | Europe
Blue | NA | product h | US
Blue | -27 | product h | US
Blue | -17 | product h | US
Blue | -21.3 | product a | Europe
Blue | 0 | product f | Europe
Blue |  | product f | Europe
Blue |  | product f | Europe
Blue | NA | product g | Europe
Blue | 0 | product g | Europe
Blue | -9.3 |  | Europe
Blue | -5 | product e | Europe
Blue | -30 | product d | Europe
Blue | -30 | product d | Europe
Blue |  |  | Europe
Blue | -25 |  | Europe
Blue | -17 | product e | US
Blue | -17 | product h | US
Blue | 0 | product e | Europe
Blue | -11 | product f | Europe
Blue | -14 | product g | Europe
Blue |  | product f | US
Blue |  | product f | US
Blue |  | product f | US
Blue |  | product f | US
Blue |  | product f | US
Blue | -16.8 | product f | US
Blue | -26 | product f | US
Blue | NA | product f | US
Blue | -15 | product d | US
Blue | -13 | product d | US
Blue | NA |  | US
Blue | -14 |  | US
Blue | NA |  | US
Blue |  |  | US
Blue |  | product c | Europe
Blue | 6 | product c | Europe
Blue |  | product c | Europe
Blue | -8 |  | Europe
Blue | NA | product g | Europe
Blue | -4.2 | product c | Europe
Blue | -5 | product b | Europe
Blue | -7.5 | product c | Europe
Blue | NA | product g | Europe
Blue | -6.3 | product b | US
Blue | 0 |  | Europe
Blue | -13 | product c | Europe
Blue | -30 | product f | Europe
Blue | NA | product f | Europe
Blue | -16 | product f | US
Blue | -18.7 | product f | US
Blue | -5 | product e | US
Blue | -25 | product e | US
Blue | 0 | product a | Europe
Blue |  | product b | Europe
Blue | -10 | product b | Europe
Blue | 0 | product b | Europe
Blue | -10 | product e | Europe
Blue | 0 | product e | Europe
Blue | -13 | product f | US
Blue |  | product f | US
Blue |  | product f | US
Blue |  | product f | US
Blue |  | product f | US
Blue |  | product f | US
Blue | 0 | product f | US
Blue | NA | product f | Europe
Blue | NA | product f | Europe
Blue | NA | product f | Europe
Blue | 1 | product f | Europe
Blue | 4 | product f | Europe
Blue | 0 | product f | Europe
Blue | -6.9 | product e | Europe
Blue | -7.1 | product g | Europe
Blue | -57 | product e | Europe
Blue | -17 |  | Europe
Blue | -17 |  | Europe
Blue | -13.6 |  | US
Blue | -8 | product g | US
Blue | NA | product f | Europe
Blue | -10 | product e | Europe
Blue | -9 |  | US
Blue |  | product g | US
Blue | -3.8 | product g | US
Blue | -15 |  | Europe
Blue | -20.3 | product d | Europe
Blue |  |  | Europe
Blue | -43 |  | Europe
Blue | -18.7 | product a | US
Blue | -18.7 |  | US
Blue | -2.6 | product f | Europe
Blue | -2.6 | product f | Europe
Blue | 11.7 | product b | US
Blue | 11.7 | product b | US
Blue | -42 | product d | Europe
Blue | -57 | product g | Europe
Blue | 0 | product g | Europe
Blue | 0 | product b | Europe
Blue | -10 | product b | Europe
Blue |  | product b | Europe
Blue | 0 | product b | Europe
Blue | -10 | product b | Europe
Blue | -9 | product h | US
Blue | NA | product h | US
Blue | -6.6 |  | US
Blue | -10.6 | product g | US
Blue | -13.2 | product a | US
Blue | -13.2 |  | US
Blue | 0 | product h | US
Blue |  | product e | US
Blue |  | product g | US
Blue |  | product e | Europe
Blue | 0 | product e | Europe
Blue | 0 | product g | Europe
Blue | -3.3 | product g | Europe
Blue | 0 | product h | Europe
Blue | NA | product g | US
Blue | -6 | product g | US
Blue | -33.3 | product d | US
Blue | NA | product d | US
Blue |  | product f | US
Blue |  | product f | US
Blue |  | product f | US
Blue | -7 | product g | Europe
Blue | -29 | product h | US
Blue | -19 | product h | US
Blue | -32 | product h | US
Red | -8.3 |  | US
Red |  | product c | Europe
Red | -3 | product e | Europe
Red | -21 | product c | Europe
Red | -4.5 | product e | Europe
Red | NA | product b | Europe
Red | -7.8 | product g | US
Red | NA |  | Europe
Red | -36.5 | product d | Europe
Red | NA | product g | Europe
Red | -24 | product g | Europe
Red | 0 | product e | US
Red | 0 | product b | Europe
Red | 0 | product e | Europe
Red | -40 | product d | Europe
Red | 0 | product g | Europe
Red | -3.3 | product h | Europe
Red | -11 | product d | US
Red | -12.2 |  | US
Red | -15 |  | US
Red | 0 | product e | Europe
Red | -22 | product g | Europe
Red | NA | product g | Europe
Red | -16 | product h | Europe
Red | NA |  | US
Red | NA |  | US
Red | NA | product b | US
Red | NA | product c | US
Red | NA | product c | US
Red | -22 | product a | Europe
Red | -20.3 |  | Europe
Red | NA | product h | Europe
Red |  | product a | Europe
Red | -12 | product g | Europe
Red |  | product g | Europe
Red |  | product g | Europe
Red | -17.5 | product a | Europe
Red | -5.9 | product e | Europe
Red | -10.3 | product g | Europe
Red | -17 | product b | US
Red | -20 | product b | Europe
Red | 0 | product e | Europe
Red | NA | product d | Europe
Red | NA | product d | Europe
Red | -5 | product e | Europe
Red | NA | product b | Europe
Red | NA | product f | Europe
Red | -5.4 | product f | Europe
Red | -5 | product f | Europe
Red | 0 | product g | Europe
Red | 0 | product e | Europe
Red | -33.3 | product b | US
Red |  | product b | US
Red | NA | product b | US
Red | NA | product b | US
Red | -33 | product a | Europe
Red | -16.8 | product a | Europe
Red | -16.3 |  | Europe
Red | NA |  | Europe
Red | -4 | product c | Europe
Red |  | product h | US
Red | -9 | product g | US
Red | -2.3 | product h | Europe
Red | -2.3 |  | Europe
Red | -3.3 | product d | Europe
Red | -3.3 | product g | Europe
Red | NA | product b | Europe
Red | 3.5 | product b | Europe
Red | 0 | product e | Europe
Red | -13 | product e | Europe
Red | -6.8 | product a | Europe
Red | -10 | product a | Europe
Red |  | product h | US
Red | -12 | product h | US
Red |  | product h | US
Red |  | product h | US
Red |  | product b | US
Red | -6.3 | product b | US
Red | -8 | product e | US
Red |  | product e | US
Red | -18.7 | product e | US
Red | -12 | product d | Europe
Red | NA | product g | Europe
Red | -13 | product g | Europe
Red | -20 | product a | US
Red | -22 | product a | US
Red | -20 |  | US
Red | NA |  | US
Red | -20 |  | US
Red | -20 | product a | US
Red | -22 | product a | US
Red | -20 |  | US
Red | NA |  | US
Red | -20 |  | US
Red | -50 | product c | US
Red | -50 | product c | US
Red | 0 | product g | Europe
Red | -6 | product d | Europe
Red | 0 | product d | Europe
Red | NA | product d | US
Red | NA |  | US
Red |  | product e | Europe
Red | 1 | product e | Europe
Red | -16 |  | Europe
Red | -40 | product b | Europe
Red | -23.3 | product c | Europe
Red | -33.3 | product e | Europe
Red | -40 | product e | Europe
Red | -1.7 | product f | US
Red |  | product f | US
Red | -23 | product e | Europe
Red | NA | product e | US
Red | -3.8 | product d | Europe
Red | -13 | product g | Europe
Red | -14 | product d | Europe
Red | -14 | product g | Europe
Red | NA | product c | Europe
Red | NA | product e | Europe
Red | NA | product b | Europe
Red | NA | product e | Europe
Red |  | product a | US
Red | NA | product h | US
Red | -27 | product h | US
Red | -17 | product h | US
Red | -33 | product c | Europe
Red | -33 | product c | Europe
Red | -14 | product e | Europe
Red | -14.8 |  | Europe
Red | NA | product e | Europe
Red | 0 |  | Europe
Red | -17 | product b | US
Red | -12 |  | US
Red | -11 | product d | US
Red | -11 |  | US
Red | -23.8 | product f | US
Red | -9 |  | Europe
Red | -9 | product c | Europe
Red | NA | product h | Europe
Red | NA | product h | Europe
Red | NA | product b | Europe
Red | -16.3 | product d | Europe
Red | -3 | product e | Europe
Red | -11 |  | Europe
Red | -10.3 |  | Europe
Red | -7.2 | product b | US
Red | NA | product e | US
Red | -22 | product f | Europe
Red |  | product f | Europe
Red | NA | product f | Europe
Red | -10.5 |  | US
Red | -10.5 | product c | US
Red | NA | product g | US
Red | NA | product g | US
Red | -13.8 |  | US
Red | -8 |  | US
Red | 6.3 | product e | Europe
Red | -11.8 | product g | Europe
Red | -9 | product e | Europe
Red | -27 | product d | Europe
Red | -13.7 | product f | US
Red | -17 | product f | US
Red | -13.7 | product f | US
Red | -33.3 | product h | Europe
Red | -33.3 |  | Europe
Red | -9.8 | product d | US
Red | -9.8 | product g | US
Red | -9.8 |  | US
Red | -9.8 |  | US
Red |  | product g | US
Red | -7.4 | product g | US
Red | -11 | product d | Europe
Red | -14.5 | product h | US
Red | -10 | product b | Europe
Red | -10 | product e | Europe
Red | 0 | product b | US
Red | 0 | product b | US
Red | NA | product h | US
Red | -15 | product h | US
Red | -15 | product h | US
Red |  | product e | US
Red | -7.5 | product g | US
Red | -13 | product b | Europe
Red | -13 | product e | Europe
Red | NA | product d | Europe
Red | NA |  | Europe
Red | -1 | product g | Europe
Red | 4 | product e | Europe
Red | 0 | product c | Europe
Red | 0 | product f | Europe
Red | 0 | product f | Europe
Red | 0 | product e | US
Red | -9 | product h | US
Red | NA | product h | US
Red | -6.6 |  | US
Red | -10.6 | product g | US
Red | -13.2 | product a | US
Red | -13.2 |  | US
Red | 0 | product h | US
Red |  | product e | US
Red | 0 | product c | Europe
Red | -6.3 | product g | Europe
Red | -11 | product h | US
Red | 0 | product g | Europe
Red | -10.6 |  | US
Red | -15.8 |  | US
Red | -10.6 |  | US
Red | NA |  | Europe
Red |  | product g | Europe
Red | NA | product g | Europe
Red | -23 | product b | Europe
Red | -23 | product c | Europe
Red | -22 | product d | Europe