[et_pb_section fb_built=”1″ _builder_version=”4.6.6″ _module_preset=”default”][et_pb_row _builder_version=”4.6.6″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.6.6″ _module_preset=”default”][et_pb_text content_tablet=”
” content_phone=”
” content_last_edited=”on|phone” _builder_version=”4.6.6″ _module_preset=”default” header_font=”Montserrat|800||on|||||” header_text_color=”#000000″ hover_enabled=”0″ sticky_enabled=”0″]
[/et_pb_text][et_pb_text content_tablet=”
Using the SUM function is one of the most fundamental tasks in Excel. The SUM function is a useful Excel tool since it allows users to add up a range of cells and numbers easily. This is particularly useful when working with large datasets.
For example, the SUM function can be used to add up the values in a column to determine the total of all the values in that column. You can also use the SUM function to add up the values in a row to determine the total value of all values within that row.
Additionally, the SUM function can also be used to add up the results of other calculations. This can be helpful if you want to perform multiple analyses on a dataset and then add up the results.
” content_phone=”
Using the SUM function is one of the most fundamental tasks in Excel. The SUM function is a useful Excel tool since it allows users to add up a range of cells and numbers easily. This is particularly useful when working with large datasets.
For example, the SUM function can be used to add up the values in a column to determine the total of all the values in that column. You can also use the SUM function to add up the values in a row to determine the total value of all values within that row.
Additionally, the SUM function can also be used to add up the results of other calculations. This can be helpful if you want to perform multiple analyses on a dataset and then add up the results.
” content_last_edited=”on|desktop” _builder_version=”4.6.6″ _module_preset=”default” text_font=”Poppins|300|||||||” text_font_size=”16px” text_line_height=”1.8em” header_2_font=”Montserrat|800||on|||||”]
Using the SUM function is one of the most fundamental tasks in Excel. The SUM function is a useful Excel tool since it allows users to add up a range of cells and numbers easily. This is particularly useful when working with large datasets.
For example, the SUM function can be used to add up the values in a column to determine the total of all the values in that column. You can also use the SUM function to add up the values in a row to determine the total value of all values within that row.
Additionally, the SUM function can also be used to add up the results of other calculations. This can be helpful if you want to perform multiple analyses on a dataset and then add up the results.
[/et_pb_text][et_pb_image src=”http://skillsharepk.com/wp-content/uploads/2023/01/SUM.jpg” alt=”Using the SUM function” title_text=”SUM” _builder_version=”4.6.6″ _module_preset=”default”][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version=”4.6.6″ _module_preset=”default”][et_pb_column type=”4_4″ _builder_version=”4.6.6″ _module_preset=”default”][et_pb_text content_tablet=”
Firstly, remember that VLOOKUP is used when looking at information in vertical columns. To be more specific, the VLOOKUP function is used when you want to search for a specific value in a range of cells and return a corresponding value from a different column in the same row.
To use the data that is in horizontal rows, use the HLOOKUP, INDEX & MATCH, or XLOOKUP functions.
However, for our article, let’s focus on VLOOKUP.
There are four inputs that you need to give to write the VLOOKUP formula. Here is the syntax for the VLOOKUP function:
=VLOOKUP(lookup_value, table_array, col_index_number, %91range_lookup%93)
” content_phone=”
Firstly, remember that VLOOKUP is used when looking at information in vertical columns. To be more specific, the VLOOKUP function is used when you want to search for a specific value in a range of cells and return a corresponding value from a different column in the same row.
To use the data that is in horizontal rows, use the HLOOKUP, INDEX & MATCH, or XLOOKUP functions.
However, for our article, let’s focus on VLOOKUP.
There are four inputs that you need to give to write the VLOOKUP formula. Here is the syntax for the VLOOKUP function:
=VLOOKUP(lookup_value, table_array, col_index_number, %91range_lookup%93)
” content_last_edited=”on|phone” _builder_version=”4.6.6″ _module_preset=”default” text_font=”Poppins|300|||||||” text_font_size=”16px” text_line_height=”1.8em” header_font=”Poppins|800|||||||” header_2_font=”Montserrat|800||on|||||” header_2_text_color=”#000000″ header_3_font=”Poppins|800|||||||” header_3_font_size=”16px” header_2_font_tablet=”” header_2_font_phone=”” header_2_font_last_edited=”on|phone” header_3_font_tablet=”” header_3_font_phone=”” header_3_font_last_edited=”on|tablet”]
The SUM function is used to add up a range of cells in Excel. The syntax of the SUM function is:
=SUM(number1, [number2])
In this case, ‘number1’ is mandatory while ‘number2’ represents an optional input. More precisely, if ‘number1’ is a single cell input, then understandably a second input must be given as well, which is represented by ‘number2’.
However, if ‘number1’ is a range of cells, then ‘number2’ is just an optional input. We’ll elaborate on this further while discussing an example.
[/et_pb_text][et_pb_text content_tablet=”
Suppose you have the data on total revenue between 2020 and 2022 given between cells B8 and F15, as shown in the table below, and you want to compute the total revenue generated for each country and in each year. You can add the numbers using the SUM function.
Recall that to use the SUM function, you will need to specify the range of cells that you want to add up and separate them with a comma.
Here is how you can calculate the total revenue generated by China in the 3 years using the SUM function. Data for China is given in the cells D9, E9, and F9.
=SUM(C9,D9,E9)
This function will add up the values in cells C9, D9, and E9.
Alternatively, you can specify the range to the abovementioned cells. Enter the following formula in cell F9:
=SUM(C9:E9)
This function will add up all of the values in the range C9:E9.
Now suppose that you want to compute the total revenue for each year. For our example, we are computing the total revenue in 2020, and data for the year 2020 is given in column C, between cells C9 and C15. We can accomplish this by using the SUM function and applying it in cell E15.
=SUM(C9:C15)
Moreover, you can also use the SUM function to add up values in multiple rows or columns by specifying a range that includes all of these cells. For example, if you want to add the total revenue in each year and each country, you can SUM all the cells in the entire range, C9 till F14.
=SUM(C9:E14)
This will add the values in the cells C9, C10, C11, C12, C13, C14, D9, D10, D11, D12, D13, D14, E9, E10, E11, E12, E13, and E14. See the picture below:
Alternatively, you can simply add the values in column F or row 15, using the SUM function. In that case, you can use the following formulas:
=SUM(C15:E15);
=SUM(F9:F14)
” content_phone=”
Suppose you have the data on total revenue between 2020 and 2022 given between cells B8 and F15, as shown in the table below, and you want to compute the total revenue generated for each country and in each year. You can add the numbers using the SUM function.
Recall that to use the SUM function, you will need to specify the range of cells that you want to add up and separate them with a comma.
Here is how you can calculate the total revenue generated by China in the 3 years using the SUM function. Data for China is given in the cells D9, E9, and F9.
=SUM(C9,D9,E9)
This function will add up the values in cells C9, D9, and E9.
Alternatively, you can specify the range to the abovementioned cells. Enter the following formula in cell F9:
=SUM(C9:E9)
This function will add up all of the values in the range C9:E9.
Now suppose that you want to compute the total revenue for each year. For our example, we are computing the total revenue in 2020, and data for the year 2020 is given in column C, between cells C9 and C15. We can accomplish this by using the SUM function and applying it in cell E15.
=SUM(C9:C15)
Moreover, you can also use the SUM function to add up values in multiple rows or columns by specifying a range that includes all of these cells. For example, if you want to add the total revenue in each year and each country, you can SUM all the cells in the entire range, C9 till F14.
=SUM(C9:E14)
This will add the values in the cells C9, C10, C11, C12, C13, C14, D9, D10, D11, D12, D13, D14, E9, E10, E11, E12, E13, and E14. See the picture below:
Alternatively, you can simply add the values in column F or row 15, using the SUM function. In that case, you can use the following formulas:
=SUM(C15:E15);
=SUM(F9:F14)
” content_last_edited=”on|phone” _builder_version=”4.6.6″ _module_preset=”default” text_font=”Poppins|300|||||||” text_font_size=”16px” text_line_height=”1.8em” header_2_font=”Montserrat|800||on|||||” header_2_text_color=”#000000″ header_3_font=”Poppins|800|||||||” header_3_font_size=”16px” header_3_font_tablet=”” header_3_font_phone=”” header_3_font_last_edited=”on|phone”]
Suppose you have the data on total revenue between 2020 and 2022 given between cells B8 and F15, as shown in the table below, and you want to compute the total revenue generated for each country and in each year. You can add the numbers using the SUM function.
Recall that to use the SUM function, you will need to specify the range of cells that you want to add up and separate them with a comma.
Here is how you can calculate the total revenue generated by China in the 3 years using the SUM function. Data for China is given in the cells D9, E9, and F9.
=SUM(C9,D9,E9)
This function will add up the values in cells C9, D9, and E9.
Alternatively, you can specify the range to the abovementioned cells. Enter the following formula in cell F9:
=SUM(C9:E9)
This function will add up all of the values in the range C9:E9.
Now suppose that you want to compute the total revenue for each year. For our example, we are computing the total revenue in 2020, and data for the year 2020 is given in column C, between cells C9 and C15. We can accomplish this by using the SUM function and applying it in cell E15.
=SUM(C9:C15)
Moreover, you can also use the SUM function to add up values in multiple rows or columns by specifying a range that includes all of these cells. For example, if you want to add the total revenue in each year and each country, you can SUM all the cells in the entire range, C9 till F14.
=SUM(C9:E14)
This will add the values in the cells C9, C10, C11, C12, C13, C14, D9, D10, D11, D12, D13, D14, E9, E10, E11, E12, E13, and E14. See the picture below:
Alternatively, you can simply add the values in column F or row 15, using the SUM function. In that case, you can use the following formulas:
=SUM(C15:E15);
=SUM(F9:F14)
[/et_pb_text][et_pb_text content_tablet=”
Tiktok
Youtube
” content_phone=”
Tiktok
Youtube
” content_last_edited=”on|tablet” _builder_version=”4.6.6″ _module_preset=”default” text_font=”Poppins|300|||||||” text_font_size=”16px” text_line_height=”1.8em” header_2_font=”Montserrat|800||on|||||” header_2_text_color=”#000000″ header_3_font=”Poppins|800|||||||” header_3_font_size=”16px” header_3_font_tablet=”” header_3_font_phone=”” header_3_font_last_edited=”on|phone”]
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]
Why do interviewers ask this interview question? "Why do you want to work here?" is…
"Where do you see yourself in 3-5 years?" is a common interview question which baffles…
What are your strengths?" This question often catches candidates off-guard who struggle to answer it…
What is the law of demand and supply? The laws of demand and supply are…
What is supply? Supply is an economic concept that refers to the total amount of…
Demand is an economic concept that captures the consumer's desire to purchase a good or…
This website uses cookies.
View Comments