CODEWITHSUNDEEP
excelexcel-formula
Yusuf Khan Mohammed
Yusuf Khan Mohammed

Reputation: 1

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.

enter image description here

Regards Yusuf

Upvotes: 0

Views: 45

Answers (1)

Dominique
Dominique

Reputation: 17493

This is exactly the reason why SUMIFS() has been invented:

enter image description here

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.

Upvotes: 2

Related Questions