Excel FP&A Web Dev Blog

Loading...

Blake Ekelund

Finance ops, half-formed plans, fully-formed spreadsheets.

Work

Excel
FP&A
Web Dev
Blog

Off the clock

Play
On my mindsoon
Golfsoon
MN Sportssoon

Find me

Email
GitHub
LinkedIn

More

Search
Sitemap
Robots

© 2026 Blake Ekelund · Built with Excel, chocky milk, and too many tabs open.

Sum of Positive Numbers – Excel LAMBDA | Blake Ekelund

Excel Toolkit›Sum of Positive Numbers

Sum of Positive Numbers

MathIntermediate

Adds only the positive numbers in a range.

LAMBDA(rng, SUM(FILTER(rng, rng > 0)))

Parameters

rng

Example Usage

=SUM_POSITIVE(A1:A20)

Pro Tips

Wrap FILTER inside IFERROR to suppress errors

Common Issues

Returns #CALC! if no positives exist

RELATED LAMBDAS IN MATH

Factorial

Recursive factorial calculation using LAMBDA recursion.

LAMBDA(n, IF(n <= 1, 1, n * FACTORIAL(n ...