SUMIF formula question

[aimee_quaife]

It's been a while since I've used excel and I'm struggling with a basic formula. Can you help.
Column C 9:22 has Y or N
Column F 9:22 has numbers I want to count IF there is a Y in column C

I tried <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #0057d6}span.s2 {color: #006107}</style>=SUMIF(C9:C22,"*Y*",F9:F22)

pressing control shift enter at the end.

It comes up with 0 instead of 16

Any thoughts on what I'm doing wrong?

Thanks!

 

[Joe4]

pressing control shift enter at the end.

You don't need to do that with a SUMIF formula.
Just try:

[COLOR=#333333]=SUMIF(C9:C22,"Y",F9:F22)[/COLOR]

 

[Norie]

If you want to count the 'Y's in C use COUNTIF.

=COUNTIF(C9:C22, "Y")

If you want to sum the numbers in F when there is a 'Y' in C use SUMIF.

=SUMIF(C9:C22, "Y", F9:22)

 

[Paul Ked]

Are your numbers stored as Text in F9:F22?