Sumif formula greater than a particular cell

[Darby]

Is there a way to use the sumif formula so that the
criteria is a > a particular cell. Ideally I'd like the
formula =sumif(A1:A10,>E1,B1:B10). With no quotes around
E1, I get an error message, with quotes I get 0 regardless
of whats in columns A & B. Seems like there must be a
simple answer.

Thanks

 

[Dave Peterson]

=sumif(A1:A10,">"&E1,B1:B10)

may work for you.

Is there a way to use the sumif formula so that the
criteria is a > a particular cell. Ideally I'd like the
formula =sumif(A1:A10,>E1,B1:B10). With no quotes around
E1, I get an error message, with quotes I get 0 regardless
of whats in columns A & B. Seems like there must be a
simple answer.

Thanks

 

[Darby]

Thanks, it works fine. Don't quite understand why but it
does. Thanks again

 

[Dave Peterson]

Inside the quotes: ">E1", you'd be really checking to see if it was larger than
the characters E1--not what was in E1.

">"&E1
just concatenates what's in E1 with that greater than sign: ">6" (if E1=6)