Results 1 to 7 of 7
  1. #1
    Bench Warmer
    Points: 11,687, Level: 32
    Level completed: 63%, Points required for next Level: 263
    Overall activity: 3.0%
    Achievements:
    Veteran10000 Experience Points
    CloneBack's Avatar
    Join Date
    Apr 2007
    Location
    West Des Moines
    Posts
    271
    Points
    11,687
    Level
    32
    Thumbs Up
    Received: 0
    Given: 1

    Excel CountIF Function Question

    I am wondering if someone might be able to help me out with the following excel function:

    =SUMIF(Week13!A:A,B2,Week13!B:B)

    When the value in B2 is compared to column A in workbook 13.. it doesn't find it. However, it returns a zero for the null value. What if I didn't want to return a zero.

    An option, is to just add the value in column A, but I want to pass back the text in the adjacent cell in column B, not the numeric vaule??? (ex. 'not found')

    Anyone?


    Ron freaking Swanson

  2. #2
    Bench Warmer
    Points: 5,848, Level: 22
    Level completed: 60%, Points required for next Level: 202
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    aweb84's Avatar
    Join Date
    Apr 2008
    Location
    St Louis Park, MN
    Posts
    230
    Points
    5,848
    Level
    22
    Thumbs Up
    Received: 0
    Given: 0

    Re: Excel CountIF Function Question

    What are you trying to do exactly? If you want a value in B2 to be compared against the values in column A you should use lookup or vlookup.



  3. #3
    Starter
    Points: 19,518, Level: 42
    Level completed: 64%, Points required for next Level: 332
    Overall activity: 14.0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Apr 2006
    Posts
    965
    Points
    19,518
    Level
    42
    Thumbs Up
    Received: 0
    Given: 0

    Re: Excel CountIF Function Question

    Ya, you're not telling ti to do anything in the SumIF formula



  4. #4
    Pro
    Points: 74,442, Level: 84
    Level completed: 76%, Points required for next Level: 408
    Overall activity: 8.0%
    Achievements:
    Veteran50000 Experience Points

    Join Date
    Mar 2006
    Posts
    2,468
    Points
    74,442
    Level
    84
    Thumbs Up
    Received: 17
    Given: 6

    Re: Excel CountIF Function Question

    I'm confused as well. That equation should function properly as long as you have numeric values in column B and what ever is in B2 has matching values in column A. That equation should give you a total of values in column B where column A has a matching value with B2.



  5. #5
    Bench Warmer
    Points: 11,687, Level: 32
    Level completed: 63%, Points required for next Level: 263
    Overall activity: 3.0%
    Achievements:
    Veteran10000 Experience Points
    CloneBack's Avatar
    Join Date
    Apr 2007
    Location
    West Des Moines
    Posts
    271
    Points
    11,687
    Level
    32
    Thumbs Up
    Received: 0
    Given: 1

    Re: Excel CountIF Function Question

    Quote Originally Posted by CloneBack View Post
    I am wondering if someone might be able to help me out with the following excel function:

    =SUMIF(Week13!A:A,B2,Week13!B:B)

    When the value in B2 is compared to column A in workbook 13.. it doesn't find it. However, it returns a zero for the null value. What if I didn't want to return a zero.

    An option, is to just add the value in column A, but I want to pass back the text in the adjacent cell in column B, not the numeric vaule??? (ex. 'not found')

    Anyone?

    =SUMIF(Week13!A:A,B2,Week13!B:B)

    I have 18 worksheets that have all of the nfl scores for this year. I am trying to pass back the score of team (insert team name) at week 13 (worksheet 13, columnA) and I want the adjacent score in columnB(how many points they scored). The problem is if they had a bye week, then it passes a zero... but the didn't play.. does that help?


    Ron freaking Swanson

  6. #6
    Pro
    Points: 74,442, Level: 84
    Level completed: 76%, Points required for next Level: 408
    Overall activity: 8.0%
    Achievements:
    Veteran50000 Experience Points

    Join Date
    Mar 2006
    Posts
    2,468
    Points
    74,442
    Level
    84
    Thumbs Up
    Received: 17
    Given: 6

    Re: Excel CountIF Function Question

    Quote Originally Posted by CloneBack View Post
    =SUMIF(Week13!A:A,B2,Week13!B:B)

    I have 18 worksheets that have all of the nfl scores for this year. I am trying to pass back the score of team (insert team name) at week 13 (worksheet 13, columnA) and I want the adjacent score in columnB(how many points they scored). The problem is if they had a bye week, then it passes a zero... but the didn't play.. does that help?
    I don't fully understand the structure of your worksheet, but I'm pretty sure you're using the wrong equations. I think a prior poster is correct that you should be using vlookup, and you can always use if statements to address the bye situation.



  7. #7
    Bench Warmer
    Points: 11,687, Level: 32
    Level completed: 63%, Points required for next Level: 263
    Overall activity: 3.0%
    Achievements:
    Veteran10000 Experience Points
    CloneBack's Avatar
    Join Date
    Apr 2007
    Location
    West Des Moines
    Posts
    271
    Points
    11,687
    Level
    32
    Thumbs Up
    Received: 0
    Given: 1

    Re: Excel CountIF Function Question

    Quote Originally Posted by mt85 View Post
    I don't fully understand the structure of your worksheet, but I'm pretty sure you're using the wrong equations. I think a prior poster is correct that you should be using vlookup, and you can always use if statements to address the bye situation.
    Thx... you are right, I should be using vlookup. I'm not an excel expert... but this helps.


    Ron freaking Swanson

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM