If help doesn't work, it sounds like you might need an installation repair.
In the meantime, you may find equivalent info at
http://office.microsoft.com/en-us/ex...042111033.aspx (or
corresponding places for other versions than 2003).
--
David Biddulph

"Jan T." wrote in message
oups.com...

First thing I tried was the Excel Help File. However it showed an
error: Cannot start Microsoft Hjelp. Also tried Goodle but searched
for SUMIF not SUMPRODUCT. Otherwise, good tip! Thanx.

On 18 Okt, 13:20, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Same syntax as in the example in Excel help:
=SUMIF(B2:B5,"<=1",E2:E5)

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

- Vis sitert tekst -