Sign in
Microsoft.com
 
Expression > Forums Home > Feedback and Discussions Forums > MSDN and TechNet Search Feedback > Excel Formula, adding up information (numeric data) meeting a range criteria (text) versus individual data lines.
Ask a questionAsk a question
Search Forums:
 

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

  • Tuesday, November 03, 2009 2:19 PMF.Perry Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    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.