# SUMIFS Units and skip such values

#### Salamullah

##### Board Regular
 Units Amount Month 100 2300 Jan 100 0.10 Jan 200 1000 Feb -200 -1000 Feb 300 2000 Jan 300 -0.08 Jan

<tbody>
</tbody>

I want to apply formula in the column A Units and wanted to skip units if Values in column B is between -0.5 to 0.5, please help based on the above example the answer of column A should be 400 in Cell E2 whereas D2 contained Jan. with SUMIFS formula

#### kweaver

##### Well-known Member
This is 400, but do you really mean SKIP within that range? If so, it wouldn't be 400 would it?

Code:
``=SUMIFS(A2:A7,B2:B7,">="&-0.5,B2:B7,"<="&0.5)``

Last edited:

#### kweaver

##### Well-known Member
Maybe you mean this:

Code:
``=SUMPRODUCT((A2:A7)*((B2:B7<=-0.5)+(B2:B7>=0.5)))``
which is 400 which is the sum of all the values in the A column that are <=-0.5 OR >=0.5

Last edited:

#### Fluff

##### MrExcel MVP, Moderator
Or is this what you want

#### Salamullah

##### Board Regular
Many thanks its working

#### Fluff

##### MrExcel MVP, Moderator
Glad we could help & thanks for the feedback.

For reference, which formula is correct?

Both