'If Matches functions in Excel
I am trying to figure out the formula for my work. I have contract values for ear service unit per month and it renew in different months in a year with different values. I am looking a formula that If I done the service in particular month ("YES") then sum the value based on "YES" and that months unit value, if "NO" then should not sum the unit value.
Hope I am clear.
Thank you for your valuable suggestions with formula.
Regards Yusuf
Solution 1:[1]
This is exactly the reason why SUMIFS() has been invented:
The formula states:
- Sum the values of column B, from B2 to B7.
- The criteria to keep in mind, are the values in C column, from C2 to C7.
- The value against which to check the criteria, is D3.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Dominique |