Excel help - sumif

[fire_munki]

Any excel gurus here?
Got a sumif statement that isn't working but doesn't give an error, just zero in the output box.

=SUMIF (C2:C50,"<>yes",E2:E50 )

C2:50 is the money owed, E2:E50 is a column with yes written in if they've paid. The formula should then total it up excluding the yes entries.

But it doesn't and I'm stumped!

 

[Selekt0r]

Just remove the "<>" from your criteria

*edit* nope, you've also got your ranges the wrong way round. The first range is the one which should contain your 'yes', and the last range the values you want to sum.

i.e. =SUMIF(E2:E50,"yes",C2:C50)

 

[Hagar]

Do you need <> ?

Range C2:C50 should be the range with yes/no I think
Sum_range E2:E50 is the range of cells to be summed.

Try that and see if it works.

 

[mattx2]

Try

=sumif(D,"yes",C:C)

 

[estebanrey]

Just remove the "<>" from your criteria

He wants to exclude yes results.

OP, your columns are the wrong way around
do this...

=SUMIF(E2:E50,"<>yes",C2:C50)

 

[ElliorR]

I'm laying in bed so can't check on Excel but do a YouTube search and view the first video, by Michael Herman, and see if that helps.

 

[Selekt0r]

He wants to exclude yes results.

OP, your columns are the wrong way around and you've formatted it wrong too

do this...

=SUMIF(E2:E50,"<>" & "yes",C2:C50)

Well spotted.

Actually, there was no problem with the criteria in the original formula ("<>yes" works fine...) - just the ranges were the wrong way round.

 

[estebanrey]

Well spotted.

Actually, there was no problem with the criteria in the original formula ("<>yes" works fine...) - just the ranges were the wrong way round.

Yeah just noticed the formatting was OK myself. I've had trouble in the past with higher than and lower than when typing it straight in so I've always broken the string up. Guess you don't need to anymore

 

[fire_munki]

Cheers, really obvious when you know!