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
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 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