Assitance on AverageIf Formula

Anyone able to lend a helping hand solving what has stumped myself and coworkers this morning?



All Sites
Division # Surveys RFI Average
Gross Net
1 5 5.00 2.60
2 8 5.75 4.25
3 8 4.43 3.43
4 6 6.67 5.33
5 5 4.20 2.40
6 7 5.71 5.00
39 5.29 3.84

Legacy Sites
Division # Surveys RFI Average
Gross Net
1 2 8.00 3.00
2 7 5.71 4.00
3 5 3.20 2.00
4 5 5.20 3.60
5 5 4.20 2.40
6 0 #DIV/0! #DIV/0!
24 #DIV/0! #DIV/0!

14 Sites
Division # Surveys RFI Average
Gross Net
1 3 3.00 2.33
2 1 6.00 6.00
3 3 7.50 7.00
4 1 14.00 14.00
5 0 #DIV/0! #DIV/0!
6 7 5.71 5.00
15 #DIV/0! #DIV/0!