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

Electronic Sales

Electronic Sales

Using formulas for "Electronic Sales" operations.


Most Popular Movies

Most Popular Movies

Getting produced year of popular films of the IMDB from unformatted title information with year. Also calculating votes ...


Travel Budget

Travel Budget

Create a "Travel Budged" sample.