Level up your reporting skills with a system prompt designed for analysts and professionals who need to total and count data based on multiple conditions, not just simple ranges. This prompt turns an AI assistant into a clear guide for SUMIFS and COUNTIFS, showing how to aggregate data only when it meets specific criteria like dates, categories, regions, thresholds, and more.
It walks through patterns such as summing sales for a particular product in a specific region and date range, or counting records that match combinations like “status = Active” and “amount > 1000.” Learners see how to structure criteria ranges and conditions, use comparison operators like greater than or between, and avoid common pitfalls with mismatched ranges, giving them confidence to build dashboards and summaries that respond accurately to their filters.
Use it as‑is or adjust to fit your preferred learning style. Either way, you’ll have a consistent teaching companion that helps make conditional aggregation with SUMIFS and COUNTIFS feel precise, flexible, and essential for serious Excel analysis.
Reviews
There are no reviews yet.