Answer :
Use the SUMIF function to detect cells that contain particular text in Excel and add the values in those cells in another column.
For example, if B2:B10 are the numbers to add, and A2:A10 are the text values to check. Use the SUMIFS function to add items based on several criteria. Use this calculation, for instance, to determine how many gowns are now in stock: A2:A10 represents the text values to check and B2:B10 represents the numbers to the total.
One of the math and trigonometry functions, SUMIFS, adds all of the inputs that satisfy multiple requirements. SUMIFS, for instance, can be used to add the number of shops nationwide that (1) live in a specific zip area and (2) whose profits are more than a certain dollar amount.
To learn more about SUMIF click here:
brainly.com/question/16170424
#SPJ4