Spreadsheet: 102240d1300217812-summing-with-multiple-conditions-every-nth-row-samplepop
Sheet: Sheet1

Year | Age Group | Total |  |  |  | what I want
1990 | 00 to 04 | 78369
1990 | 05 to 09 | 69788 |  |  |  | Year | 40-49 | 50-59
1990 | 10 to 14 | 59635 |  |  |  | 1990 | 134977 | 84288
1990 | 15 to 19 | 59189 |  |  |  | 1991 | 140511 | 85718
1990 | 20 to 24 | 83225 |  |  |  | 1992
1990 | 25 to 29 | 109083 |  |  |  | 1993
1990 | 30 to 34 | 107143 |  |  |  | 1994
1990 | 35 to 39 | 92987 |  |  |  | 1995
1990 | 40 to 44 | 78176 |  |  |  | 1996
1990 | 45 to 49 | 56801 |  |  |  | 1997
1990 | 50 to 54 | 45017 |  |  |  | 1998
1990 | 55 to 59 | 39271 |  |  |  | 1999
1990 | 60 to 64 | 39173 |  |  |  | 2000
1990 | 65 to 69 | 35961 |  |  |  | 2001
1990 | 70 to 74 | 28604 |  |  |  | 2002
1990 | 75 to 79 | 21990 |  |  |  | 2003
1990 | 80 to 84 | 15742 |  |  |  | 2004
1990 | 85+ | 14978 |  |  |  | 2005
1991 | 00 to 04 | 77257 |  |  |  | 2006
1991 | 05 to 09 | 70796 |  |  |  | 2007
1991 | 10 to 14 | 62461 |  |  |  | 2008
1991 | 15 to 19 | 57484 |  |  |  | 2009
1991 | 20 to 24 | 81900
1991 | 25 to 29 | 105271
1991 | 30 to 34 | 109004
1991 | 35 to 39 | 94955
1991 | 40 to 44 | 82574
1991 | 45 to 49 | 57937
1991 | 50 to 54 | 46511
1991 | 55 to 59 | 39207
1991 | 60 to 64 | 38832
1991 | 65 to 69 | 35676
1991 | 70 to 74 | 28988
1991 | 75 to 79 | 22852
1991 | 80 to 84 | 16121
1991 | 85+ | 15394
1992 | 00 to 04 | 76783
1992 | 05 to 09 | 71580
1992 | 10 to 14 | 65256
1992 | 15 to 19 | 57801
1992 | 20 to 24 | 80052
1992 | 25 to 29 | 100731
1992 | 30 to 34 | 109615
1992 | 35 to 39 | 96518
1992 | 40 to 44 | 82978
1992 | 45 to 49 | 62867
1992 | 50 to 54 | 48216
1992 | 55 to 59 | 39395
1992 | 60 to 64 | 37920
1992 | 65 to 69 | 35272
1992 | 70 to 74 | 29606
1992 | 75 to 79 | 23429
1992 | 80 to 84 | 16507
1992 | 85+ | 15690
1993 | 00 to 04 | 75601
1993 | 05 to 09 | 72212
1993 | 10 to 14 | 67565
1993 | 15 to 19 | 59366
1993 | 20 to 24 | 78856
1993 | 25 to 29 | 97002
1993 | 30 to 34 | 109806
1993 | 35 to 39 | 98622
1993 | 40 to 44 | 84980
1993 | 45 to 49 | 65473
1993 | 50 to 54 | 51251
1993 | 55 to 59 | 40339
1993 | 60 to 64 | 36983
1993 | 65 to 69 | 35022
1993 | 70 to 74 | 29740
1993 | 75 to 79 | 23935
1993 | 80 to 84 | 16832
1993 | 85+ | 16030
1994 | 00 to 04 | 74274
1994 | 05 to 09 | 73412
1994 | 10 to 14 | 69101
1994 | 15 to 19 | 61599
1994 | 20 to 24 | 77208
1994 | 25 to 29 | 94390
1994 | 30 to 34 | 109101
1994 | 35 to 39 | 100395
1994 | 40 to 44 | 87111
1994 | 45 to 49 | 69057
1994 | 50 to 54 | 53516
1994 | 55 to 59 | 41486
1994 | 60 to 64 | 36197
1994 | 65 to 69 | 34420
1994 | 70 to 74 | 29837
1994 | 75 to 79 | 24474
1994 | 80 to 84 | 17090
1994 | 85+ | 16362
1995 | 00 to 04 | 72652
1995 | 05 to 09 | 73999
1995 | 10 to 14 | 70170
1995 | 15 to 19 | 64334
1995 | 20 to 24 | 75456
1995 | 25 to 29 | 93375
1995 | 30 to 34 | 106794
1995 | 35 to 39 | 101982
1995 | 40 to 44 | 88893
1995 | 45 to 49 | 73113
1995 | 50 to 54 | 55481
1995 | 55 to 59 | 42227
1995 | 60 to 64 | 35822
1995 | 65 to 69 | 33834
1995 | 70 to 74 | 30068
1995 | 75 to 79 | 24607
1995 | 80 to 84 | 17517
1995 | 85+ | 16608
1996 | 00 to 04 | 71641
1996 | 05 to 09 | 74186
1996 | 10 to 14 | 70961
1996 | 15 to 19 | 67009
1996 | 20 to 24 | 73693
1996 | 25 to 29 | 93782
1996 | 30 to 34 | 103493
1996 | 35 to 39 | 102865
1996 | 40 to 44 | 90493
1996 | 45 to 49 | 77808
1996 | 50 to 54 | 56707
1996 | 55 to 59 | 43257
1996 | 60 to 64 | 35388
1996 | 65 to 69 | 33165
1996 | 70 to 74 | 29680
1996 | 75 to 79 | 24959
1996 | 80 to 84 | 17852
1996 | 85+ | 16818
1997 | 00 to 04 | 71380
1997 | 05 to 09 | 75017
1997 | 10 to 14 | 71836
1997 | 15 to 19 | 68965
1997 | 20 to 24 | 73687
1997 | 25 to 29 | 92918
1997 | 30 to 34 | 99265
1997 | 35 to 39 | 102318
1997 | 40 to 44 | 91624
1997 | 45 to 49 | 78927
1997 | 50 to 54 | 61699
1997 | 55 to 59 | 44507
1997 | 60 to 64 | 35245
1997 | 65 to 69 | 32303
1997 | 70 to 74 | 29395
1997 | 75 to 79 | 25579
1997 | 80 to 84 | 17925
1997 | 85+ | 17105
1998 | 00 to 04 | 72084
1998 | 05 to 09 | 75940
1998 | 10 to 14 | 73332
1998 | 15 to 19 | 71067
1998 | 20 to 24 | 75192
1998 | 25 to 29 | 92080
1998 | 30 to 34 | 95487
1998 | 35 to 39 | 101208
1998 | 40 to 44 | 92809
1998 | 45 to 49 | 81153
1998 | 50 to 54 | 64162
1998 | 55 to 59 | 46708
1998 | 60 to 64 | 35682
1998 | 65 to 69 | 31232
1998 | 70 to 74 | 29442
1998 | 75 to 79 | 25911
1998 | 80 to 84 | 18139
1998 | 85+ | 17374
1999 | 00 to 04 | 72877
1999 | 05 to 09 | 75978
1999 | 10 to 14 | 74665
1999 | 15 to 19 | 72141
1999 | 20 to 24 | 77749
1999 | 25 to 29 | 91618
1999 | 30 to 34 | 93096
1999 | 35 to 39 | 99473
1999 | 40 to 44 | 93924
1999 | 45 to 49 | 83655
1999 | 50 to 54 | 67670
1999 | 55 to 59 | 48298
1999 | 60 to 64 | 36309
1999 | 65 to 69 | 30529
1999 | 70 to 74 | 29452
1999 | 75 to 79 | 26249
1999 | 80 to 84 | 18382
1999 | 85+ | 17569
2000 | 00 to 04 | 73394
2000 | 05 to 09 | 75517
2000 | 10 to 14 | 75466
2000 | 15 to 19 | 72934
2000 | 20 to 24 | 79878
2000 | 25 to 29 | 90775
2000 | 30 to 34 | 92622
2000 | 35 to 39 | 96810
2000 | 40 to 44 | 94965
2000 | 45 to 49 | 85847
2000 | 50 to 54 | 71514
2000 | 55 to 59 | 49726
2000 | 60 to 64 | 36562
2000 | 65 to 69 | 30156
2000 | 70 to 74 | 29336
2000 | 75 to 79 | 26447
2000 | 80 to 84 | 18595
2000 | 85+ | 17683
2001 | 00 to 04 | 75143
2001 | 05 to 09 | 73874
2001 | 10 to 14 | 75744
2001 | 15 to 19 | 72872
2001 | 20 to 24 | 82147
2001 | 25 to 29 | 89569
2001 | 30 to 34 | 92884
2001 | 35 to 39 | 93599
2001 | 40 to 44 | 96004
2001 | 45 to 49 | 86843
2001 | 50 to 54 | 75794
2001 | 55 to 59 | 51086
2001 | 60 to 64 | 37401
2001 | 65 to 69 | 29961
2001 | 70 to 74 | 28556
2001 | 75 to 79 | 26492
2001 | 80 to 84 | 18879
2001 | 85+ | 18081
2002 | 00 to 04 | 75501
2002 | 05 to 09 | 71844
2002 | 10 to 14 | 75349
2002 | 15 to 19 | 72679
2002 | 20 to 24 | 82197
2002 | 25 to 29 | 90162
2002 | 30 to 34 | 90954
2002 | 35 to 39 | 89737
2002 | 40 to 44 | 95270
2002 | 45 to 49 | 87713
2002 | 50 to 54 | 76225
2002 | 55 to 59 | 55547
2002 | 60 to 64 | 38485
2002 | 65 to 69 | 29826
2002 | 70 to 74 | 27863
2002 | 75 to 79 | 26270
2002 | 80 to 84 | 19297
2002 | 85+ | 18306
2003 | 00 to 04 | 76117
2003 | 05 to 09 | 69967
2003 | 10 to 14 | 74486
2003 | 15 to 19 | 72972
2003 | 20 to 24 | 81752
2003 | 25 to 29 | 92526
2003 | 30 to 34 | 88505
2003 | 35 to 39 | 85904
2003 | 40 to 44 | 94092
2003 | 45 to 49 | 88690
2003 | 50 to 54 | 77334
2003 | 55 to 59 | 57831
2003 | 60 to 64 | 40558
2003 | 65 to 69 | 30137
2003 | 70 to 74 | 27267
2003 | 75 to 79 | 25716
2003 | 80 to 84 | 19732
2003 | 85+ | 18699
2004 | 00 to 04 | 77896
2004 | 05 to 09 | 68250
2004 | 10 to 14 | 73393
2004 | 15 to 19 | 73010
2004 | 20 to 24 | 79871
2004 | 25 to 29 | 96034
2004 | 30 to 34 | 85511
2004 | 35 to 39 | 83511
2004 | 40 to 44 | 92738
2004 | 45 to 49 | 88896
2004 | 50 to 54 | 78888
2004 | 55 to 59 | 60858
2004 | 60 to 64 | 42170
2004 | 65 to 69 | 30705
2004 | 70 to 74 | 26660
2004 | 75 to 79 | 25155
2004 | 80 to 84 | 20081
2004 | 85+ | 19067
2005 | 00 to 04 | 78872
2005 | 05 to 09 | 67050
2005 | 10 to 14 | 71366
2005 | 15 to 19 | 72832
2005 | 20 to 24 | 78002
2005 | 25 to 29 | 99086
2005 | 30 to 34 | 82553
2005 | 35 to 39 | 82509
2005 | 40 to 44 | 90057
2005 | 45 to 49 | 89545
2005 | 50 to 54 | 80069
2005 | 55 to 59 | 64668
2005 | 60 to 64 | 43360
2005 | 65 to 69 | 31232
2005 | 70 to 74 | 26135
2005 | 75 to 79 | 24649
2005 | 80 to 84 | 20337
2005 | 85+ | 19383
2006 | 00 to 04 | 78604
2006 | 05 to 09 | 67962
2006 | 10 to 14 | 69735
2006 | 15 to 19 | 72721
2006 | 20 to 24 | 77656
2006 | 25 to 29 | 101464
2006 | 30 to 34 | 81533
2006 | 35 to 39 | 82308
2006 | 40 to 44 | 86565
2006 | 45 to 49 | 90439
2006 | 50 to 54 | 80943
2006 | 55 to 59 | 68631
2006 | 60 to 64 | 44563
2006 | 65 to 69 | 31867
2006 | 70 to 74 | 25995
2006 | 75 to 79 | 24022
2006 | 80 to 84 | 20388
2006 | 85+ | 19956
2007 | 00 to 04 | 79959
2007 | 05 to 09 | 68840
2007 | 10 to 14 | 67877
2007 | 15 to 19 | 72759
2007 | 20 to 24 | 77480
2007 | 25 to 29 | 102923
2007 | 30 to 34 | 83871
2007 | 35 to 39 | 81736
2007 | 40 to 44 | 83520
2007 | 45 to 49 | 90176
2007 | 50 to 54 | 82511
2007 | 55 to 59 | 69345
2007 | 60 to 64 | 49065
2007 | 65 to 69 | 33208
2007 | 70 to 74 | 26112
2007 | 75 to 79 | 23623
2007 | 80 to 84 | 20315
2007 | 85+ | 20666
2008 | 00 to 04 | 80492
2008 | 05 to 09 | 70197
2008 | 10 to 14 | 66806
2008 | 15 to 19 | 72441
2008 | 20 to 24 | 77328
2008 | 25 to 29 | 103474
2008 | 30 to 34 | 87771
2008 | 35 to 39 | 81021
2008 | 40 to 44 | 80727
2008 | 45 to 49 | 89829
2008 | 50 to 54 | 84137
2008 | 55 to 59 | 71308
2008 | 60 to 64 | 51602
2008 | 65 to 69 | 35464
2008 | 70 to 74 | 26524
2008 | 75 to 79 | 23395
2008 | 80 to 84 | 20058
2008 | 85+ | 21289
2009 | 00 to 04 | 80292
2009 | 05 to 09 | 72848
2009 | 10 to 14 | 65718
2009 | 15 to 19 | 71849
2009 | 20 to 24 | 77455
2009 | 25 to 29 | 102742
2009 | 30 to 34 | 93176
2009 | 35 to 39 | 79859
2009 | 40 to 44 | 79528
2009 | 45 to 49 | 89382
2009 | 50 to 54 | 85209
2009 | 55 to 59 | 74063
2009 | 60 to 64 | 55056
2009 | 65 to 69 | 37276
2009 | 70 to 74 | 27143
2009 | 75 to 79 | 22965
2009 | 80 to 84 | 19803
2009 | 85+ | 21848