Learn one useful thing today.
Count, sum and find the maximum in a selected column with CHOOSECOLS
Select a metric by its unique header, then use SUMPRODUCT to count qualifying rows or total a region and MAX for all regions.
Read the guide →MathCOUNTIF & SUMIF Across Non-Contiguous Ranges (Additive & VSTACK)
Count matching rows and sum quantities from two separate blocks, with literal criteria and a dynamic-array alternative.
Read the guide →Checking repeated recordsCOUNTIF in Excel: flag repeated IDs before changing the data
Count repeated booking identifiers, keep blank IDs out of the flags, and distinguish repeated rows from extra copies.
Read the guide →Dates and reportingCOUNTIFS between dates: count a full month, including timestamps
Count open repair tickets received in March. Use an inclusive start and an exclusive next-month boundary so a ticket arriving late on the final day is included.
Read the guide →Counting recordsCOUNTIFS: count open orders above a minimum amount
Count qualifying orders without adding their values. This example combines an order status with a minimum amount and checks what happens exactly at the threshold.
Read the guide →FinancialCoupon-date bond valuation with PV: par, discount and premium
Price a simplified fixed-coupon bond on a coupon date and compare its current yield with yield to maturity.
Read the guide →Antitrust Economics & M&A StrategyCournot Merger Paradox & 80% Threshold Formula
Prove Salant, Switzer & Reynolds’s (1983) Cournot Merger Paradox: without cost synergies, merging M of N symmetric Cournot rivals loses money unless M >= 80% of the industry.
Read the guide →Industrial Organization & Antitrust EconomicsCournot Oligopoly Nash Price and Cowling-Waterson HHI Lerner Formula
Solve N = 3 asymmetric Cournot-Nash equilibrium price P* = (a + SUM c_i) / (N + 1), firm outputs q_i = (P* - c_i) / b, and verify Cowling and Waterson’s HHI / |e_D| markup identity.
Read the guide →LogicalCourse & onboarding completion matrix formula ("Complete", "In Progress 3/4", "Not Started")
Summarize explicit X completion marks for four modules and calculate the share of listed learners with every module marked.
Read the guide →Counting & Conditional AggregationCourse Completion & Compliance Pass-Rate Summary With COUNTIFS
Calculate LMS training compliance rates (%) requiring both Status = "Completed" and Exam Score >= Passing Cutoff using COUNTIFS(C2:C7, "Completed", D2:D7, ">=" & F2) / COUNTA(A2:A7).
Read the guide →FinancialCovered Interest Rate Parity (CIRP): FX forward rate & forward points formula
Compute an illustrative FX forward parity benchmark using simple annual rates, a common day basis and a stated quote convention.
Read the guide →Health & FitnessCox Survival Arithmetic: Framingham and Historical Pooled Cohort Context
Explore the survival transformation shared by some historical cardiovascular risk models, with model-specific parameters and no automatic clinical classification.
Read the guide →Financial ModelingCox-Ingersoll-Ross (CIR) Short-Rate Zero-Coupon Bond Price, Yield & Feller Condition
Price affine zero-coupon bonds under the Cox-Ingersoll-Ross (1985) square-root diffusion dr = a(b - r)dt + sigma*sqrt(r)dW with closed-form A(T), B(T), and Feller positivity ratio 2ab / sigma^2.
Read the guide →Actuarial Science & Insurance RiskCramér-Lundberg Ruin Probability & Adjustment Coefficient R
Calculate relative security loading theta, Cramér-Lundberg adjustment coefficient R = theta / ((1 + theta) * mu), Lundberg ruin bound EXP(-R * u_0), and exact exponential ruin probability.
Read the guide →StatisticalCramer's V effect size & Chi-Square contingency table association formula
Calculate Chi-Square SUM((O - E)^2 / E) and sample-size-adjusted Cramer's V = SQRT(ChiSq / (N * MIN(r - 1, c - 1))) for categorical cross-tabulations.
Read the guide →Aerospace Cost Estimating & OperationsCrawford Unit vs Wright Learning Curve Formula
Avoid a 44% unit-cost bidding error by distinguishing J. R. Crawford’s Incremental Unit Learning Curve Y_n = T_1 * n^b from T. P. Wright’s Cumulative-Average Unit Difference T_1*(n^(1+b) - (n-1)^(1+b)).
Read the guide →Commercial Real Estate & Mortgage FinanceCRE Debt Yield, Loan Constant & Leverage Spread Formula
Underwrite commercial real estate via Debt Yield = NOI / Loan, Monthly-Pay Annual Loan Constant k_debt, DSCR = Debt_Yield / k_debt, and Positive vs Negative Cash-on-Cash Leverage.
Read the guide →Dynamic ArraysCreate a date sequence between two dates with SEQUENCE
Generate an inclusive daily or weekly calendar column dynamically from StartDate and EndDate using SEQUENCE(End - Start + 1, 1, Start, 1).
Read the guide →TextCreate a project-specific URL matching key
Build a simplified host/path comparison key only where your project explicitly treats these URL variants as equivalent.
Read the guide →TextCreate display masks for synthetic identifiers and email addresses
Practice last-four display masking with synthetic text values. A masked output does not remove or secure the original data.
Read the guide →TextCreate standardized email addresses from first and last name columns
Build lowercase first.last@domain email addresses while stripping stray spaces and apostrophes from multi-part surnames.
Read the guide →Healthcare & ClinicalCRIB II Research and Temperature Unit Conversion in Spreadsheets
Learn about the CRIB II research and convert fictional temperatures between Celsius and Fahrenheit.
Read the guide →Project Management & Operations ResearchCritical Chain Root-Sum-of-Squares Buffer Formula
Pool task contingencies into Eliyahu Goldratt’s (1997) Critical Chain Project Buffer PB_SSQ = SQRT(SUM((P90_i - P50_i)^2)) and monitor execution with the Fever-Chart Buffer Burn Index.
Read the guide →Statistical & MathCronbach’s Alpha (alpha) Internal Consistency & Spearman-Brown Prophecy
Calculate psychometric test reliability Cronbach’s alpha = (K / (K - 1)) * (1 - Sum_Item_Var / Total_Score_Var) and Spearman-Brown predicted reliability for scaled test length.
Read the guide →FX Derivatives & International Money MarketsCross-Currency Basis & CIP Deviation Formula
Calculate 1-Year FX Forward Premium, FX-Swapped Synthetic USD Rate, Du-Tepper-Verdelhan Cross-Currency Basis Spread (bps), and Hedged USD Cash-Lender Arbitrage Pickup.
Read the guide →Petroleum Refining & Midstream BlendingCrude Oil API Gravity & Pipeline Blend Formula
Convert API Gravity to 60°F Specific Gravity SG = 141.5 / (API + 131.5), compute Exact Volumetric Blended Specific Gravity, and recover True Blended API Gravity without linear-API averaging error.
Read the guide →Healthcare & Clinical CalculationsCRUSADE Bleeding Score: An Educational Point-Sum Example
Add invented CRUSADE component points with discrete-value checks. This worksheet does not estimate individual bleeding risk or prescribe care.
Read the guide →Industrial Gases, Cryogenic Distillation & Steel/Gasification UtilitiesCryogenic Air Separation Unit (ASU) Oxygen & Power Formula
Calculate Cryogenic ASU Dry-Air Intake Flow (Nm³/hr), Daily Pure Oxygen Tonnage (t/day), Main Air Compressor Power (MW), and Total Pipeline GOX Electrical Load (MW).
Read the guide →Aerospace LH2/LN2 Storage & MRI Cryostats, Multi-Layer Superinsulation (MLI) Boil-OffCryogenic Dewar MLI Heat Leak & NER Boil-Off Formula
Calculate MLI Blanket Radiative/Conductive Shell Leak (W), Total Parasitic Heat Load Including Neck/Supports (W), Daily Boil-Off Mass (kg/d), and Normal Evaporation Rate NER (%/d).
Read the guide →Medical Imaging Physics, Computed Tomography (CT) QA & Radiodensity WindowingCT Hounsfield Unit (HU) & Display Window Grayscale Formula
Calculate Calibrated Hounsfield Unit HU = 1000*(mu_x - mu_water)/(mu_water - mu_air), Lower/Upper Display Window Bounds, and 8-Bit Monitor Grayscale Intensity (0–255).
Read the guide →Math & TrigCube root and nth root formula: positive and negative numbers
Raise numbers to fractional exponent ^(1/n) for any root degree, and pair SIGN with ABS for negative odd roots.
Read the guide →StatisticalCumulative (expanding) average formula: AVERAGE($B$2:B5)
Track season-to-date or year-to-date running averages with an expanding range $B$2:B2 that locks row 2 and grows automatically as you copy down.
Read the guide →Finance & AccountingCumulative Loan Principal & Interest Paid Between Two Periods (FV & PMT)
Calculate exact cumulative principal and cumulative interest paid between any start period s and end period e without building a 360-row amortization schedule using FV balance differences.
Read the guide →Clinical Medicine & PhysiologyCunningham Equations: Fat-Free Mass and Energy Estimates
Compare the 1980 and 1991 body-composition equations with a fictional example and an assumed activity multiplier.
Read the guide →StatisticalCURB-65 and qSOFA: separate score formulas with boundary tests
Practice IF and OR using fictional CURB-65 and qSOFA inputs, explicit units and separate mental-status criteria.
Read the guide →Engineering & ScienceCurie-Weiss Paramagnetic Susceptibility & Effective Bohr Magneton (mu_eff)
Calculate molar magnetic susceptibility chi_m = C / (T - theta_CW) above magnetic ordering temperatures and extract unpaired d/f-electron effective moment mu_eff = SQRT(8 * C_cgs) in Bohr magnetons (mu_B).
Read the guide →FinancialCurrency conversion formula: cross-currency FX table with XLOOKUP
Convert between any pair of currencies (EUR to USD, EUR to GBP, JPY to EUR) from a single USD-anchored FX table—no N-by-N matrix needed.
Read the guide →EngineeringCurrent Divider Rule & Thevenin Maximum Power Transfer Theorem formulas
Split parallel branch currents using opposite resistance I_1 = I_total * (R_2 / (R_1 + R_2)) and verify Thevenin load power P_L = V_th^2 * R_L / (R_th + R_L)^2 peaking at R_L = R_th.
Read the guide →FinancialCurrent Ratio, Quick Ratio (Acid-Test), and Net Working Capital (NWC)
Calculate current and quick ratios and compare total working capital with one explicitly defined operating-working-capital measure.
Read the guide →Date & TimeCustom 1-letter ("MTWRFSU") & 2-letter weekday abbreviations (WEEKDAY, MID & CHOOSE)
Map numeric dates to explicitly chosen one- or two-letter weekday labels, independently of localized weekday names.
Read the guide →Data Validation & AuditingCustom Data Validation: Numbers Only, Text Only, Whole %, & Weekdays Only
Enforce strict type, whole-percentage integer step, and Monday–Friday business-day rules on intake rows using ISNUMBER, ISTEXT, MOD, and WEEKDAY(date, 2) <= 5.
Read the guide →Dynamic arraysCustom sort order with formula: rank Critical, High, Medium, Low using SORTBY
Map non-alphabetical status labels to a custom priority table with XMATCH and sort rows automatically via SORTBY.
Read the guide →FinancialCustomer Lifetime Value (LTV), LTV:CAC ratio, and CAC Payback formula
Calculate gross-margin-adjusted Customer Lifetime Value (ARPU * GrossMargin / Churn), LTV:CAC ratio, and months to recover Customer Acquisition Cost.
Read the guide →ScienceCyclotron Frequency, Larmor Gyroradius & MRI Proton Larmor Frequency
Calculate charged-particle Cyclotron Frequency f_c = |q| * B / (2 * PI() * m) (MHz), magnetic Larmor Gyroradius r_L = (m * v_perp) / (|q| * B) (mm), and 1H MRI nuclear Larmor resonance (42.577 MHz/T).
Read the guide →Engine Block Tribology & Bore Finishing, Plateau Honing Included Crosshatch AngleCylinder-Bore Honing Crosshatch Angle & Speed Formula
Calculate Hone Stone Rotary Surface Speed vr (m/min), Mean Axial Reciprocating Speed va (m/min), Resultant Cutting Speed vres (m/min), and Included Crosshatch Angle 2·alpha (deg).
Read the guide →Crystal Growth, Silicon Wafer Boules & Dopant SegregationCzochralski Silicon Ingot Dopant Segregation Profile Formula
Calculate Seed-End Crystal Dopant Concentration C_s(0), Solidified-Fraction Ingot Concentration C_s(g), Enriched Crucible Melt Concentration C_L(g), and Tail-to-Seed Resistivity Drift Ratio.
Read the guide →Political Economy, Governance & Resource Allocationd’Hondt vs Sainte-Laguë Seat Apportionment Formula
Compare Victor d’Hondt (divisors 1, 2, 3) against André Sainte-Laguë (odd divisors 1, 3, 5) highest-averages apportionment using LARGE and COUNTIF across multi-party seat allocations.
Read the guide →Transportation Logistics & Last-Mile OperationsDaganzo Milk-Run Vehicle Routing Length Formula
Estimate multi-stop fleet tour mileage using Carlos Daganzo’s (1984) continuous approximation L_fleet = 2 * r_stem * m_tours + k_tsp * SQRT(N_stops * Area) and quantify consolidation savings.
Read the guide →EngineeringDalton partial pressure and Henry equilibrium concentration formulas
Calculate ideal-mixture partial pressure and dilute-solution equilibrium concentration with an explicitly defined Henry solubility coefficient.
Read the guide →Engineering & ScienceDamköhler Number (Da): Isothermal First-Order CSTR vs. PFR Conversion
Calculate the first-order reactor Damköhler number Da = k * tau and compare continuous stirred-tank conversion X_CSTR = Da / (1 + Da) against plug-flow conversion X_PFR = 1 - EXP(-Da).
Read the guide →