Excel: How to Calculate Average If Cell Contains Text - Statology You can use the following formula to calculate the average in Excel only for the cells that contain a specific text: This particular formula will calculate the average of the values in the range B1:B13 only for the cells that contain “text” in the range A1:A13
How to Calculate Average of Text in Excel (2 Ways) To calculate the average number of text, we have to first count the times a particular product appears in the entries Then calculate its average using the simple average formula (i e , count total count)