Forum Discussion
If formula
Is there a formula that would look at a range of cells and add up the values in those cells only if the value was within a certain range? For instance, suppose I have the following range of cells: ...
You can use SUMIFS(A1:A5;A1:A5;">200";A1:A5;"<400")
This formula sums all numbers in A1:A5 but only if in A1:A5 are >200 and in A1:A5 are <400. You have to repeat the A1:A5 in order to explain to the machine where to check the conditions, even if it's always the same range.
