How to make Averaging between two numbers
Formula:
=AVERAGE(A1:J1)
____________________________
5
6
7
8
9
10
11
12
13
5
____________________________
Description:
See the above formula, if your date with in the range A1 to J1 then the average will show any place where you have placed the cursor.
The result will be populate 8.6
Count, how much value do you have with the range
=COUNT(A1:J1)
The result will be populate 10
Count, how many “5” do you have with the range
=COUNTIF(A1:J1, "5")
The result will be populate 2, because with the range only 2 value available with the formula condition
Count Text
Same way you can count a “text” with a certain data range. Just change the “5” to your desired word.
As an example; you have some data with the word “Apple”. You need to count how many “Apple” word available with in your data. Same way apply this formula-
=COUNTIF(A1:J1, "Apple")
=COUNTIF(A1:A10,">=5")
=COUNTIF(A1:A10,">10")
=COUNTIF(A1:A10,">=5")-COUNTIF(A1:A10,">10")
Reflect a particular word
Suppose you are doing profit and loss calculation and if the figure comes with profit then you might want to show the ward “Profit” before the figure. Or if the figure comes in loss the definitely the word is “Loss”.
How can we make it-
=IF(J5 >0, "Profit","Loss")
If we describe the formula; ‘J5’ means where the profit or loss value will populate. If the value less the 0, suppose ‘–1000’; that means loss by 1000 Dollar. The formula result will display “Loss”, other then “Profit”.
You can modify this formula and can with other condition.
Let’s practices this formula. I will add some more function time to time.
