Excel CountIF Function Question

[CloneBack]

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?

 

[aweb84]

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.

 

[Cloner97]

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

 

[mt85]

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.

 

[CloneBack]

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?

 

[mt85]

=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.

 

[CloneBack]

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.