| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| sumif formula | Excel Worksheet Functions | |||
| Formula using SUMIF & IF | Excel Worksheet Functions | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
![Jan T.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
