Building up the formula...
Section match
Section Values
Section A 1 Section A 1
Section A 2 Section B 14
Section A 3 Section C 22
Section A 1 Section D 23
Section A 2
Section A 3
Section A 1
Section A 2
Section A 3
Section A 1
Section A 2 (checking the sums)
Section A 3
Section A 1 25
Section B 2
Section B 3
Section B 1
Section B 2
Section B 3
Section B 1
Section B 2
Section B 3 17
Section C 1 1
Section D 2
Section D 3
Section D 1
Section D 2
Section D 3
Section D 1
Section D 2 14
p the formula...
countif column offset offset combined function (using sum as Or using names ranges
example computation)
13 1 1 25 1
8 1 #VALUE! 17 2
1 1 1 1 3
7 1 #VALUE! 14 1
2
3
1
2
3
1
2
3
1
#N/A
Or using names ranges