Spreadsheet: 130267d1322146473-can-i-have-cells-sum-if-it-text-and-not-numbers-junctions
Sheet: Drain order

 |  |  |  |  |  |  |  |  |  |  |  |  | Junctions |  |  | standard |  |  |  |  |  |  |  | 2 O'Clock & 10 O'Clock
 |  |  |  |  |  |  |  |  |  |  |  |  | 100 | x | 100 |  |  |  |  |  |  |  |  | 1No at 2 O'Clock & 1No at 10 O'Clock
 |  |  |  |  |  |  |  |  |  |  |  |  | 150 | x | 100 |  |  |  |  |  |  |  |  | this is the other junction type it cloud be
 |  |  |  |  |  |  |  |  |  |  |  |  | 150 | x | 150 |  |  |  |  |  |  |  |  | as seen on drain runs AE6
 |  |  |  |  |  |  |  |  |  |  |  |  | 225 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 225 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 225 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 300 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 300 | x | 150 |  |  |  |  |  |  |  | I don’t know why this cell isnt adding in?
 |  |  |  |  |  |  |  |  |  |  |  |  | 300 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 300 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 375 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 375 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 375 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 375 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 375 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 450 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 450 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 450 | x | 225 |  | I don’t really want all these columns if there is an easier way to do it
 |  |  |  |  |  |  |  |  |  |  |  |  | 450 | x | 300 |  | I just want it to look at the junction size e.g. 300 x 150 and if it is any of the
 |  |  |  |  |  |  |  |  |  |  |  |  | 450 | x | 375 |  | six columns to sum it and put the answer here
 |  |  |  |  |  |  |  |  |  |  |  |  | 450 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 525 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 525 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 525 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 525 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 525 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 525 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 525 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 600 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 600 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 600 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 600 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 600 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 600 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 600 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 600 | x | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 675 | x | 675
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 675
 |  |  |  |  |  |  |  |  |  |  |  |  | 750 | x | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 675
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | 825 | x | 825
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 675
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 825
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | x | 900
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 675
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 825
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 900
 |  |  |  |  |  |  |  |  |  |  |  |  | 1050 | x | 1050
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 675
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 825
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 900
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 1050
 |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | x | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 225
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 300
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 375
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 450
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 525
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 675
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 750
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 825
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 900
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 1050
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | x | 1500