Same syntax as in the example in Excel help:
=SUMIF(B2:B5,"<=1",E2:E5)
--
David Biddulph

"Jan T." wrote in message
ups.com...
I have a table where I want to sum Colum E, Data.
However I only want to sum those rows where the same row in Column B
have the value <=1.

I tried to set the condition OR(1,<1) but does not work. Also tried
=SUMIF(B2:B5, OR(B2:B5=1,B2:B5<1),E2:E5) and held dowm Ctrl + Shift.

How should I write the formula to make it work? Any idea?

Thanks for any help.

Regards
Jan T.