See Numstro in action with real-world examples
Calculate commission based on sales performance and tier structure
Sales Rep, Region, Sales Amount, Commission Rate"Sum commission amounts for sales reps in the North region where sales are greater than $10,000"
=SUMIFS(D2:D100, B2:B100, "North", C2:C100, ">10000")Sums values in the commission column (D) for rows where region is "North" and sales amount is greater than $10,000
Analyze conversion rates and identify bottlenecks in marketing funnels
Campaign, Stage, Visitors, Conversions"Count how many campaigns have a conversion rate above 5%"
=COUNTIFS(D2:D100/C2:C100, ">0.05")Counts campaigns where the conversion rate (conversions divided by visitors) is greater than 5%
Project revenue based on multiple product lines and growth rates
Product, Q1 Revenue, Q2 Revenue, Q3 Revenue, Q4 Revenue"Average quarterly revenue for products where total annual revenue exceeds $100,000"
=AVERAGEIFS(B2:E100, SUM(B2:E2), ">100000")Averages quarterly revenue values for products where the sum of all quarters is greater than $100,000
Track deals through sales stages and calculate pipeline value
Deal Name, Stage, Amount, Close Date"Sum deal amounts for opportunities in "Negotiation" stage that are closing this month"
=SUMIFS(C2:C100, B2:B100, "Negotiation", D2:D100, ">="&EOMONTH(TODAY(),-1)+1, D2:D100, "<="&EOMONTH(TODAY(),0))Sums deal amounts where stage is "Negotiation" and close date is within the current month
Track inventory levels and identify items needing reorder
Product SKU, Category, Current Stock, Reorder Level"Count products where current stock is below reorder level"
=COUNTIFS(C2:C100, "<"&D2:D100)Counts products where the current stock value is less than the reorder level
Upload your own data and see how Numstro can help you generate Excel formulas
Launch Formula Builder