Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← The library

Math function

COMBINA

Returns the number of combinations with repetitions allowed.

Rarely usedDifficulty 1300 · ProficientUsage rank #299 of 520

Practice · 2 questions →

When to use it

Combinations with repetition allowed: the ways to pick k items from n types when you can pick the same type more than once. Ice-cream scoops, dice outcomes, order lines.

The shape of it

Syntax: =COMBINA(number, number_chosen)

Worked examples

Scoops from flavors
=COMBINA(4,3) → 20
Three scoops from four flavors, repeats allowed.
Small case
=COMBINA(3,2) → 6
Pairs from three types with repeats: AA, AB, AC, BB, BC, CC.
Larger case
=COMBINA(10,3) → 220
Equals COMBIN(12,3).

Worth knowing

COMBINA(n,k) = COMBIN(n+k-1,k).
COMBIN is the no-repeats version.
Non-integers are truncated.

Where it goes wrong

#NUM! for negative arguments.
COMBINA(0,0) is 1, which can surprise.

SUM SUMIF SUMIFS ROUND ABS SUMPRODUCT

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.