On 18 Okt, 13:10, Mike H wrote:
OOps typo

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



"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.- Skjul sitert tekst -

- Vis sitert tekst -


That was perfect. The only change I did, was this:
I changed the number 1 to 1.001 because otherwice the formula will
just sum integers (whole numbers). If the value is 1.5 it reads only
1.

Thank you very much for your good and fast answer.

Regards
Jan T.