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

L

Loan

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

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
 
B

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)
 
Top