In this Excel video tutorial, we gonna see how to Add Up Cells that Contain a Specific Word or Variations of that Word in Excel using the sumif function or sumif formula in Excel.

The sum if formula in Excel is one of the best functions in my opinion, because it can help us automate tasks and save time in Excel, as well as helping us create Excel analyzes and create important Excel reports.

Basically, the sum if formula can add up, not all the values, but only the values that correspond to a specific criterion.

In this free Excel tutorial, we are going to do something even more specific and objective, we are going to add up all the cells that contain a word and it doesn't matter, if that word appears accompanied by other words, within the same cell, or if that word appears alone. We will do the an addition every time any variation of that word appears in a list using the sum if function.

#JopaExcel #Dashboard #Excel