Information Technology IT – 8 Spreadsheets | e-Consult

Question

Question 3

A company has a list of customer orders in a spreadsheet. The columns are: A - Order ID, B - Customer Name, C - Order Date, D - Order Value. You need to calculate the number of orders placed by customers whose names contain the letter 'a'. Describe how you would use a spreadsheet function to achieve this. Include the function name and provide a formula example.

Answer 1

To count the number of orders placed by customers whose names contain the letter 'a', I would use the COUNTIF function combined with the SEARCH function. The COUNTIF function counts the number of cells within a range that meet a given criteria. The SEARCH function finds the position of a specified text string within a text string. If the text string is found, it returns the starting position; otherwise, it returns an error.

The formula would be:

=COUNTIF(B:B, "*a*")

Explanation:

B:B: This is the range containing the customer names.

"*a*": This is the criteria. The asterisks (*) are wildcards, meaning they can represent any sequence of characters. Therefore, "*a*" will match any customer name that contains the letter 'a' anywhere within it.

COUNTIF will count the number of customer names in column B that match the criteria.

Information Technology IT – 8 Spreadsheets | e-Consult

8 Spreadsheets (1 questions)

Question 3

Support e-Consult Kenya