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)


"Biff" wrote in message
...
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

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

.