Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "conditional sum"

94 prompts matching "conditional sum"

"conditional sum" ✕ Clear all ✕
excel Intermediate

Excel Project Gantt Chart from Task List

Generate an Excel Gantt chart from a task list with columns Task, Start Date, Du...

#excel #gantt #project-management
👁 9 views
excel Intermediate

Turn a messy operational export into a pivot table that someone will actually read

I have an operational export with [N] rows and columns like [DATE, REGION, PRODU...

#excel #pivot tables #reporting
👁 9 views
coding Intermediate

Write a SQL query that you'll still understand in six months

Write a SQL query that answers this question: [QUESTION]. Tables and columns I h...

#coding #sql #readability
👁 9 views
excel Intermediate

Build a Rolling 12-Month Cash Flow Forecast in Excel

You are an Excel financial modeling expert. Help me build a rolling 12-month cas...

#excel #cash flow #forecast
👁 9 views
excel Intermediate

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#excel #pivot-tables #executive-reporting
👁 8 views
excel Intermediate

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

#excel #vlookup #reconciliation
👁 8 views
marketing Advanced

Find the activation moment that predicts a paying user

You are a growth analyst. We have [N] signed-up users and want to find the singl...

#marketing #growth #activation
👁 8 views
excel Beginner

Design a self-updating Excel tracker with data validation

Help me build an Excel tracker (for tasks, inventory, or expenses — I'll tell yo...

#excel #data validation #conditional formatting
👁 8 views
excel Advanced

Build a self-checking Excel template that catches user-entered errors before they propagate

I'm building a template that non-technical colleagues will fill in monthly. Past...

#excel #template #validation
👁 7 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Excel Inventory Reorder-Point Calculator with Safety Stock

I'm building a reorder-point sheet for [number] SKUs in Excel. For each SKU I ha...

#excel #inventory #reorder
👁 6 views
excel Intermediate

Excel Inventory Reorder Point Calculator

Build an Excel template that calculates the reorder point for each SKU using lea...

#excel #inventory #reorder-point
👁 6 views
finance Intermediate

Finance: Decide Whether to Invest Now or Wait, Without Pretending to Time the Market

I have cash sitting in a savings account and I'm torn about when to invest. Help...

#finance #investing #dca
👁 6 views
excel Intermediate

Excel: Rebuild a Pivot That Lies to Stakeholders

Look at this pivot table setup: [PASTE COLUMNS, FILTERS, AND VALUES]. Tell me wh...

#excel #pivot-tables #analysis
👁 6 views
data Intermediate

Translate a Business Question into a Defensible SQL Query

You are an analytics engineer. I will paste a fuzzy business question (e.g., 'ho...

#sql #analytics #business-questions
👁 6 views
excel Intermediate

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

#excel #sumifs #debugging
👁 6 views
excel Beginner

Excel: Build a Pivot Table That Answers the Question Your Boss Actually Asked

I have a dataset and a vague question from leadership. Help me design a pivot ta...

#excel #pivot-tables #reporting
👁 5 views
excel Intermediate

Design a Pivot Table for Monthly Sales Analysis

You are an expert Excel reporting analyst. Guide me through building a pivot tab...

#excel #pivot-table #sales
👁 5 views
excel Intermediate

Create a Self-Updating Excel Project Tracker with Gantt View

Act as a project management consultant. Build me a self-updating Excel project t...

#gantt #project-tracker #dashboard
👁 4 views
writing Advanced

Outline a 3,000-word essay that earns the length, not pads to it

Act as a long-form essay editor. I want to write 3,000 words on [TOPIC] with the...

#writing #essay #outline
👁 4 views
business Intermediate

Build a Weighted Decision Matrix

You are an expert decision analyst. Help me choose between options objectively u...

#business #decision-making #matrix
👁 4 views
excel Intermediate

Design a Pivot Table Reporting Plan

You are an Excel reporting consultant. Based on the dataset I describe, design t...

#excel #pivot-table #reporting
👁 4 views
excel Advanced

Diagnose a Slow Excel Workbook

You are an Excel performance consultant. I will describe my workbook's symptoms ...

#excel #performance #optimization
👁 4 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval