SUMIFS is the most important function in Excel. We can use it to answer business questions quickly and easily.
In this simple tutorial learn how to use SUMIFS to answer 5 questions.
0:00 - Introduction
1:10 - Total amount for a specific product
3:36 - Total amount based on two conditions
4:32 - Fixing problems with SUMIFS
5:06 - Total amount based on wildcards
6:35 - Total based on first letter
7:49 - Total between two values
9:20 - Homework problems (post answers in comments)
Sample file download chesukondi
chandoo.org/wp/wp-content/upl...
More Excel Functions:
IF - • IF Function in Excel -...
XLOOKUP - • Excel lo best function...
Playlist - • IF Function in Excel -...
Inka kavala nayana?
-------------------------------
Aithe subscribe chesukondi. New videos every week 😀
#Excel #excelintelugu
Негізгі бет How to use SUMIFS in Excel - Telugu Tutorial
Пікірлер: 46