Final answer:
Summary and SUM IF functions are meant for numerical data aggregation and conditionally summing numbers, not for text/picklist fields.
Step-by-step explanation:
The functions you are referring to, summary and SUM IF, typically operate on numerical data. In the context of spreadsheet applications and database management, these functions are used to aggregate numerical values based on certain conditions (SUM IF) or to provide totals, averages, counts, and other types of summaries for a set of data (summary).
When it comes to text or picklist fields, these functions do not perform the same way. Summary functions might count the occurrences of text values or determine the presence of unique entries, but they do not 'sum up' texts. Similarly, the SUM IF function is designed to add numbers conditionally, not to work with text. It requires a condition that, when met, leads to the summation of numerical values in a range or array.
Therefore, the answer to your question is b. No, summary and SUM IF functions do not work on text/picklist fields in terms of calculating a sum as they would with numerical data.