Criteria with "<" or ">" in sumif()

[Guest]

Hi, my excel version doesn't recognise the arrows in sumif formulas. What
can I do to make it work? Thanks heaps.

 

[Biff]

Hi!

What does your formula look like?

To use a logical operator, try one of these:

=SUMIF(A1:A10,">5")

=SUMIF(A1:A10,">"&5)

Biff

 

[Bob Phillips]

or

=SUMIF(A1:A10,">"&H1,B1:B10)

to cover the value in another cell and summing a different row.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Debra Dalgleish]

There's an example of using SUMIF with an operator here:

http://www.contextures.com/xlFunctions01.html#Operator