Maybe

=SUMPRODUCT((B1:B6<=-1)*(E1:E6))

Mike

"Jan T." wrote:

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.