In this tutorial you will learn How to Calculate Average If Cell Contains Text in Google Sheets
You can use the following formula to calculate the average in Google Sheets only for the cells that contain a specific text:
To Calculate Average If Cell Contains Text in Google Sheets you can use the AVERAGEIF Function
=AVERAGEIF(A2:A9,"*text*",B2:B9)
Let’s use the above formula in a step by step example
How to Calculate Average If Cell Contains Text in Google Sheets : Step by Step Guide
Here’s How to Calculate Average If Cell Contains Text in Google Sheets
Step 1 : Open Google Sheets
Step 2 : Prepare your dataset
Assuming we have a dataset consisting of 8 football teams with number of Points scored in a Footbal Wordcup tournament.
Step 3 : Use the formula to Calculate Average
Use the following formula AVERAGEIF function you can calculate the average points scored by the footbal teams where a team consists of text “ne”
=AVERAGEIF(A2:A9,"*ne*",B2:B9)
The above AVERAGEIF function will caclulate the average values between the range B2:B9 only for specific cells thats consists of text “ne” in the range A2:A9
This particular formula will calculate the average of the values in the range B2:B13 only for the cells that contain “text” in the range A2:A13.
Note: The asterisks, which function as wildcard characters, instruct Google Sheets to disregard any text that comes before or after a certain string.
Type the formula in the Cell for example C2 where you need the result
Now Press enter
The average points scored by teams with text “ne” in the teams name is 6.5.
In the above example we have two teams Netherlands and Senegal which consists of text “ne” in the name.
Let’s Calculate the average points scored by the teams Manually
Average Points Scored = (7 + 6) / 2= 6.5.
The manually calculated value matches with the result calculate by the AVERAGEIF function 👍😃
Check the following link to find the complete documentation related to AVERAGEIF function
How to Calculate Average If Cell Contains Text in Google Sheets(Conclusion)
In the above tutorial we have shown you a step by step guide to calculate avergae if the cell contains text in Google Sheets.
We hope this tutorial was helpful.
Related posts:
How to Insert Spin Button in Google Sheets ( Easy Guide )
How to Freeze Rows in Google Sheets
How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)
How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )
