Spreadsheet: 758928d1639156858-need-help-around-correct-formulae-nested-if-or-index-for-attached-query-excel-test
Sheet: Q1

 | Question 1
 | Answer |  | Question |  |  | Group Segment 1 | Group Segment 2 | Revenue
 |  |  | Find the sum of revenue where Group Segment 1 is "Small" & Group Segment 2 is also "Small" |  |  | Medium | Medium | 8249.327669812732
 |  |  |  |  |  | Medium | Small | 6557.872983221948
 |  |  |  |  |  | Small | Medium | 6180.035747198115
 |  |  |  |  |  | Medium | Small | 9915.454311225049
 |  |  |  |  |  | Small | Small | 4047.669178088143
 |  |  |  |  |  | Small | Small | 4797.087504576099
 |  |  |  |  |  | Small | Medium | 6537.800101016741
 |  |  |  |  |  | Medium | Big | 3151.422775370376
 |  |  |  |  |  | Big | Medium | 9504.7818270498
 |  |  |  |  |  | Medium | Big | 9378.140469958493
 |  |  |  |  |  | Big | Small | 6772.133042437305
 |  |  |  |  |  | Small | Big | 1854.632158189805
 |  |  |  |  |  | Big | Small | 8303.94266432503
 |  |  |  |  |  | Small | Small | 6741.460063930609
 |  |  |  |  |  | Small | Small | 4151.439757679469
 |  |  |  |  |  | Small | Big | 7972.301890703199
 |  |  |  |  |  | Big | Small | 10331.5784748428
 |  |  |  |  |  | Small | Small | 3695.193020761345
 |  |  |  |  |  | Small | Medium | 7904.293625193724
 |  |  |  |  |  | Medium | Big | 849.2599248438665
 |  |  |  |  |  | Big | Medium | 7157.627548900796
 |  |  |  |  |  | Medium | Small | 3712.565012325079
 |  |  |  |  |  | Small | Small | 7596.439503101213
 |  |  |  |  |  | Small | Big | 2198.657792500172
 |  |  |  |  |  | Big | Medium | 4723.995875112472
 |  |  |  |  |  | Medium | Medium | 1331.264518015268
 |  |  |  |  |  | Medium | Big | 2743.802618756203
 |  |  |  |  |  | Big | Small | 5038.30681337436
 |  |  |  |  |  | Small | Small | 10458.26601690812
 |  |  |  |  |  | Small | Big | 7567.035149327575
 |  |  |  |  |  | Big | Small | 7688.434158578413
 |  |  |  |  |  | Small | Medium | 4023.227380365045
 |  |  |  |  |  | Medium | Medium | 4551.603669889431
 |  |  |  |  |  | Medium | Small | 2665.1140925001
 |  |  |  |  |  | Small | Medium | 6589.124662448583
 |  |  |  |  |  | Medium | Medium | 5220.426939804658
 |  |  |  |  |  | Medium | Small | 7282.188756589392
 |  |  |  |  |  | Small | Small | 6444.583630646055
 |  |  |  |  |  | Small | Small | 10299.02926033918
 |  |  |  |  |  | Small | Small | 9841.229575433941
 |  |  |  |  |  | Small | Medium | 8237.8478361811
 |  |  |  |  |  | Medium | Medium | 6221.24862226355
 |  |  |  |  |  | Medium | Small | 5401.241818766459
 |  |  |  |  |  | Small | Big | 10013.81117444989
 |  |  |  |  |  | Big | Small | 8466.699812222643
 |  |  |  |  |  | Small | Small | 8382.214302109172
 |  |  |  |  |  | Small | Small | 8105.417292175996
 |  |  |  |  |  | Small | Small | 10051.25538980094
 |  |  |  |  |  | Small | Small | 3667.201190339799
 |  |  |  |  |  | Small | Small | 7822.061839128237
 |  |  |  |  |  | Small | Small | 4575.527171532412
 |  |  |  |  |  | Small | Small | 3178.196918731778
 |  |  |  |  |  | Small | Medium | 1734.412428793428
 |  |  |  |  |  | Medium | Medium | 8601.066096188815
 |  |  |  |  |  | Medium | Medium | 8328.445677269689
 |  |  |  |  |  | Medium | Medium | 9715.270000706547
 |  |  |  |  |  | Medium | Medium | 4722.773351656185
 |  |  |  |  |  | Medium | Small | 3434.694117705206
 |  |  |  |  |  | Small | Medium | 8696.755983384928
 |  |  |  |  |  | Medium | Big | 9195.079595144125
 |  |  |  |  |  | Big | Big | 4168.871714810304
 |  |  |  |  |  | Big | Medium | 885.2432428381608
 |  |  |  |  |  | Medium | Small | 3222.210542621404
 |  |  |  |  |  | Small | Small | 3185.181743330517
 |  |  |  |  |  | Small | Small | 5050.975927690863
 |  |  |  |  |  | Small | Small | 306.0780834123237
 |  |  |  |  |  | Small | Small | 9598.976748510246
 |  |  |  |  |  | Small | Medium | 10338.80064909117
 |  |  |  |  |  | Medium | Small | 7350.612289834769
 |  |  |  |  |  | Small | Small | 7506.472644537209
 |  |  |  |  |  | Small | Big | 1939.781098266686
 |  |  |  |  |  | Big | Big | 7692.216849408847
 |  |  |  |  |  | Big | Medium | 1060.486546427932
 |  |  |  |  |  | Medium | Small | 738.5081579279375
 |  |  |  |  |  | Small | Small | 8174.839178421432
 |  |  |  |  |  | Small | Small | 4368.806237131396
 |  |  |  |  |  | Small | Big | 1292.519502923664
 |  |  |  |  |  | Big | Big | 2210.748757010846
 |  |  |  |  |  | Big | Small | 4240.744632037136
 |  |  |  |  |  | Small | Small | 5927.042030461668
 |  |  |  |  |  | Small | Small | 2597.353659596936
 |  |  |  |  |  | Small | Small | 9549.486816786392
 |  |  |  |  |  | Small | Small | 3931.334369796807
 |  |  |  |  |  | Small | Big | 8578.803579999229
 |  |  |  |  |  | Big | Medium | 1946.136655630598
 |  |  |  |  |  | Medium | Medium | 9021.016431018083
 |  |  |  |  |  | Medium | Big | 5575.671739764255
 |  |  |  |  |  | Big | Small | 1193.066162292705
 |  |  |  |  |  | Small | Small | 10340.53334627444
 |  |  |  |  |  | Small | Medium | 5512.767656832919
 |  |  |  |  |  | Medium | Small | 2555.999067180736
 |  |  |  |  |  | Small | Medium | 10157.81366963766
 |  |  |  |  |  | Medium | Big | 8921.52185675644
 |  |  |  |  |  | Big | Medium | 10494.44330169101
 |  |  |  |  |  | Medium | Medium | 7007.768244715191
 |  |  |  |  |  | Medium | Small | 4811.037753031506
 |  |  |  |  |  | Small | Medium | 8657.827185002598
 |  |  |  |  |  | Medium | Small | 8204.320599481856
 |  |  |  |  |  | Small | Medium | 4246.883191475362