Sum opeation of wanted cell in a list

You can use SUMIF() function here. First you write the range of where you search the cell.

Secondly, you write the searched characters some cells have.

Lastly, you write the range of list where the data is for summation. 

"*" refers that there are some characters after searched characters.

Related Trainings

Beverage Sales

Beverage Sales

Drill down your sales data using an alternative lookup method.


Highest Paid Celebrities

Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insights using rankings, basic statististics and conditional sta...


Hotel California

Hotel California

Basic revenue calculation by implementing stays, discounts and tax.