I have an issue with `SUMIF`

function that drives me crazy. The thing is that looks like the Excel calculate the `SUMIF`

till a point and not in the entire cells range (even with same length in `range`

and `sum_range`

).

Here's the example:

```
A B C
-------------------------------
1| 5 | Type1 | 50
2| 10 | Type2 |
3| 5 | Type2 | 35
4| 10 | Type1 |
5| 5 | Type2 |
```

`C3`

is the cell that contains the `SUMIF`

function like this: `=C1-SUMIF(B1:B5;"Type2";A1:A5)`

(`C1`

has a simple `SUM`

function from other data) but as you can see the function doesn't work propertry. `C3`

shuld have the value `30`

instead of `35`

. The value of `A5`

ins't sume in the `SUMIF`

, and so on if you continue to adds rows to the table (even updating the ranges).

That's my problem here. The `SUMIF`

function is right: `range;criteria;sum_range`

so why isn't analyzing data in the entire `A1:A5 B1:B5`

range? What i'm doing wrong?

*- I'm using Excel 2016*

`SUMIF`

`C3`

should have the value`30`

instead of`35`

", but whatever's going on here, "the function doesn't work properly" is not it. When I set up the scenario as described here, the values are correct. If it's not @cybernetic.nomad 's suggestion that you have trailing spaces, there's something else you haven't told us (or noticed) that's throwing you off.`Type2`

where typed, I used Excel's autocomplete for write the othersCurrency(`A`

column) andGeneral(`B`

column)data types for all the cases. The other think is that`C1`

are involved in the operation, but`C1`

is just a simple`SUM(D1:D5)`

if`D`

column exists. This operation`=C1-SUMIF(*;*;*)`

can be a problem?`=C1-SUMIF(B:B;"Type2";A:A)`

?6more comments