Information Technology IT – 8 Spreadsheets | e-Consult

Question

Question 1

A retail company has collected sales data for several products over a period of months. The data is in a spreadsheet with the following columns: A - Product Name, B - Month, C - Sales Revenue. You need to calculate the total sales revenue for 'Widget X' across all months. Describe how you would use a spreadsheet function to achieve this. Include the function name and provide a formula example.

Answer 1

To calculate the total sales revenue for 'Widget X', I would use the SUMIF function. SUMIF sums the values in a range that meet a given criteria. In this case, the criteria is that the product name must be 'Widget X'.

The formula would be:

=SUMIF(A:A, "Widget X", C:C)

Explanation:

A:A: This is the range containing the product names.

"Widget X": This is the criteria – the product name we are looking for.

C:C: This is the range containing the sales revenue. The function will sum the values in this range only if the corresponding product name in column A matches "Widget X".

Information Technology IT – 8 Spreadsheets | e-Consult

8 Spreadsheets (1 questions)

Question 1