ExcelPro — AI Formula Helper

🤖

Ask me anything about Excel

Describe what you want to do in plain English. I'll explain exactly which formula to use, how to write it, and why it works.

Formula Reference

SUM

Adds up a range of numbers

=SUM(number1, [number2], ...)

VLOOKUP

Finds a value in a table by matching a lookup value

=VLOOKUP(value, table, col, [exact])

Returns different values based on a condition

=IF(condition, value_if_true, value_if_false)

SUMIF

Sums values that match a single condition

=SUMIF(range, criteria, sum_range)

COUNTIF

Counts cells that match a condition

=COUNTIF(range, criteria)

XLOOKUP

Modern replacement for VLOOKUP — more flexible

=XLOOKUP(value, lookup_array, return_array)

INDEX MATCH

Powerful lookup combination — works in any direction

=INDEX(return_range, MATCH(value, lookup_range, 0))