Use the data given below to answer the following question(s).
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter (April-June).

-While constructing frequency distributions for numerical data, SUMIF is used to count the frequencies of each discrete value.

Question

Use the data given below to answer the following question(s).
Following is the purchase order database of 'The Chef Says So', a restaurant in New York, over the last quarter (April-June).
 
-While constructing frequency distributions for numerical data, SUMIF is used to count the frequencies of each discrete value.

Quizplus · Accepted Answer

SUMIF is used to sum values based on a condition, not to count frequencies. COUNTIF is used to count frequencies of each discrete value in a dataset.

Use the Data Given Below to Answer the Following Question(s)