Summary of SUMAR las celdas que TENGAN una Palabra en su contenido, en EXCEL.

00:00:00 - 00:15:00

This video explains how to use the SUMMAR function in Excel to total the cells that contain a word. The example shows how to total the cells that contain the word "cement." The video also explains how to use the RANGE and SUM functions to sum multiple ranges of data.

• 00:00:00 This video shows how to use the SUMAR function in Excel to total the cells that contain a word. The example shows how to total the cells that contain the word "cement."
• 00:05:00 In this video, Claudia Perez explains how to use the SUMAR function in Excel. She starts by showing how to enter a range of cells that contain a word, and then shows how to use the SUMAR function to sum the values in that range. She also explains how to use the RANGE and SUM functions to sum multiple ranges of data.
• 00:10:00 This video explains how to use the SUMMAR function in Excel to quickly see what cells contain a certain word. If you forget any other cells, just use an asterisk at the beginning and end of the word you're trying to remember, and Excel will do the rest. For example, if you wanted to summarize the contents of cells A1, B1, and C1 with the word "truth," you would type: SUMMAR A1*B1+C1 However, if you wanted to summarize the contents of cells A1, B1, and C1 with the word "Cement," you would type: SUMMAR A1*(B1+C1)
• 00:15:00 This video explains how to use a Greek word in Excel. The video shows how to enter the word in Greek characters and how to use it in a formula. Then, the video explains how to create a formula that uses the word as an argument. Finally, the video shows how to preview the results of the formula.