Get a clear summary from the range of values
Ideal for use in domains like market research, academic studies, or financial analysis; this function can summarize columns of customer reviews, lengthy reports, or even complex datasets, providing quick insights without the need to sift through pages of information. 

Expected Output:
Mid-size summary of this range
=SUMMARIZE_X(A2:A50, TRUE,  {"act_like", "Customer Service Analyst"})

Expected Output:
Summary of the A2:A50 range in bullet point from a Customer Service Analyst perspective
=SUMMARIZE_X(Sheet2!B5:D20, FALSE, {"mode", "extensive"; "act_like", "Financial Analyst"; "extra_instructions", "Focus on quarterly trends"; "output_language", "Most popular language in the region " & Regions!B5})

Expected Output:
Detailed summary with a focus on quarterly trends from the perspective of a financial analyst, using language prevalent in the region from cell B5 of the Regions sheet.
=SUMMARIZE(FILTER(A2:G100, D2:D100 > 7), FALSE, {"mode", "balanced"})

Expected Output:
Provide a balanced summary of the user's reviews with a rating over 7.
Arguments List
=SUMMARIZE_X(range, [as_bullet_points],[options])
=SUMMARIZE_Y(range, [as_bullet_points],[options])
Options List
Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"output_language","French"; "extra_instructions","Remember this info: " & A1; "act_like","Data Analyst"}
Websheet AI is designed to empower you in crafting the perfect website effortlessly. Discover the myriad of options and bring your vision to life.