![]() Write down the specific criteria in E9 and E10.Take a separate column E for the criteria and F for the total quantity.In order to add the sum range based on a specific text criteria, we need to: This is a grocery list with a range that contains specific repeated text. Let’s have a look on how is it done with a slight change in the formula Using SUMIF if cells contain specific textįormula for specific text: =SUMIF(range,”criterianame”,sum_range) With the help of SUMIF Function, we can also add cells that contain specific or partial text and even if the cells contain numbers and text altogether, they can also be added. ![]() Using the SUMIF Function to Add Cells if They Contain Certain Text
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |