मैत्री वरील कविता
दुःख अडवायला उंबऱ्यासारखा ,
मित्र वनव्यामध्ये गारव्यासारखा……… १
वाट चुकणार नाही जीवनभर कोणी,
एक तू मित्र कर आरशासारखा,
मित्र वनव्यामध्ये गारव्यासारखा……. २
आत्महत्याच करणार नाही कोणी,
मित्र असला जवळ जर मनासारखा,
मित्र वनव्यामध्ये गारव्यासारखा…….. ३
त्रासलो जिंदगी चाळताना पुन्हा,
बस धडा मैत्री वाचण्यासारखा,
मित्र वनव्यामध्ये गारव्यासारखा……. ४
मैत्री चाटते गाय होऊन मना,
जा बिलग तू तिला वासरासारखा,
मित्र वनव्यामध्ये गारव्यासारखा…… ५
कवी अनंत राऊत
Purpose of using Countif formula
Countif formula is used to count the number of cells that meet specific single criteria
What is the output of countif formula?
This formula returns the count of cells in the selected range which satisfy the mentioned criteria
What are the steps to use countif formula?
1. Select a cell where you want the output
2. Type a formula like this =countif
3. Double click on Countif formula
4. Now it will ask range so select the range of cells. This range contains the criteria which we are going to apply
5. Press comma(,)
6. Enter a criteria. If it is a text then type it in double inverted comma “criteria”. If criteria is in a numeric form then no need to press “”.
7. Then hit enter
We will see the example
Suppose we have a list of students and their result (Pass/Fail) and we want to count the number of Pass students and number of Fail students then we will use countif function
Now select a cell and type =countif formula and double click on it. Now select a range as show in picture and press comma ,
We want to count Pass students. Hence type “Pass” in criteria argument.
Now hit enter to see the result as count of pass students
Similarly countif can be used to count Fail students. Follow the same steps up to the selection of range and type Fail in criteria.
Hit enter key. You can see the count of Fail students
In this way countif function has its application from basic level to advance level. This can improve you efficiency of working on excel.
Basically sum if formula is used to sum the values based on criteria specified by you.
Syntax of SUMIF formula are explained below
SUMIF(range, criteria, [sum_range])
"Range" is the range of cells you want to evaluate.
"Criteria" is the condition or criteria that you want to apply.
"Sum_range" is the range of cells to sum if the criteria or condition is met.
Let us see how to use it practically with example.
So, if you have sold different books in different regions and you have its data maintained in sheet. Then you can use sumif formula to calculate region wise total sale of all books.
Steps to do that are as below.
Step 1. Write a data in organized form
Step 2. Start writing sumif formula as "=sumif"
Step 3. Now formula will ask range to select. So select the range from which criteria will be selected.
Then press comma(,) and select the criteria. Here our criteria is East region. Hence select East and press comma(,).
Step 4. Now formula will ask to select sum range. Select the cells from which want to sum the values.
.png)
