Excel Formula, adding up information (numeric data) meeting a range criteria (text) versus individual data lines.

Question

I am trying to add up information in a range meeting specific criteria.

=SUMIF($G149:$G200,$W$4:$W$73,$H$149:$H$200)
              range            criteria          sum range

However it returns to me as zero when I know there are values in this range. I have re written it to be

=SUMIF($G75:$G148,W50,$I$75:$I$148)
                               single criteria
Returns with solid numbers, but then I have to add each line. It can be possibly 12 or more lines added to my spreadsheet and then added together each week.