Thread: SUMIF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jan T.[_2_] Jan T.[_2_] is offline
external usenet poster
 
Posts: 9
Default SUMIF formula

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.