Menu Close

7 Useful Excel Functions – I Ask [29] Experts About It

Here I present a list of the most useful functions in Excel.

29 Experts, who run great Excel Blog, send me their favorites.

In fact, I use those functions to do almost all my tasks in Excel.

Below are the list and each expert’s opinion.

Let’s drive-in.

Function #1 IF

If Function - the most useful excel function

Expert’s votes – 22

This is the most usefull -> the IF function, which allows you to check logical condition and give you what you want.

Function #2 XLOOKUP

second useful Excel function - xlookup function - basic use

Expert’s votes – 19

The second one is XLOOKUP function, which help you to search a range or an array, and give you back the item corresponding to the first match.

Function #3 FILTER

filter - useful function in excel - screen shot

Expert’s votes – 16

The last on the podium FILTER function, which filters a data based on supplied criteria and return matching records.

Function #4 INDEX

excel index function

Expert’s votes – 15

The Excel INDEX function returns the value at a given location in a range or array.

Function #5 SUMIFS

sumif function in ms excel

Expert’s votes – 14

To sum cells and meet multiple criteria, SUMIFS function goes in.

Function #6 MATCH

match function - basic use

Expert’s votes – 12

MATCH function you use to find the position of a lookup value in a row, column to meet criteria.

Function #7 SUMPRODUCT

sumproduct as excel function - screen shot

Expert’s votes – 11

To multiplies the range of cells, you can use SUMPRODUCT function.

# All votes and functions #

Top useful Excel function - graph ranking

# Expert’s list #

Below you can find a list of all Excel Experts, who joined this article.

Their run great blogs or Excel YouTube channels.

# Bill Jelen #

mrexcel.com

Bill Jelen - MrExcel

Top function according to Bill Jelen:

  • IF
  • LAMBDA
  • MAKEARRAY
  • TEXTJOIN
  • XLOOKUP
  • SUMIFS
  • FILTER

Web page: mrexcel.com

YouTube channel

# Leila Gharani #

xelplus.com

Leila Gharani - YouTube

Top function according to Leila Gharani:

  • IF
  • SUM
  • SUMIFS
  • COUNT
  • COUNTIFS
  • XLOOKUP
  • FILTER
  • UNIQUE
  • SORT
  • INDEX

Web page: xelplus.com

YouTube channel

# Purna Duggirala #

chandoo.org

Chandoo Purna Duggirala

Top function according to Purna Duggirala:

  • IF
  • IFS
  • SUMIFS
  • COUNTIFS
  • XLOOKUP
  • FILTER
  • SUBTOTAL

Web page: chandoo.org

YouTube channel

# Mynda Treacy #

myonlinetraininghub.com

Mynda Treacy MyOnlineTrainingHub - YouTube

Top function according to Mynda Treacy:

  • INDEX
  • IF
  • UNIQUE
  • SORTBY
  • GETPIVOTDATA
  • XLOOKUP
  • SUMPRODUCT
  • LET
  • LAMBDA
  • FILTER

Web page: myonlinetraininghub.com

YouTube channel

# Debra Dalgleish #

contextures.com

Debra Dalgleish (@ddalgleish) | Twitter | Contextures

Top function according to Debra Dalgleish:

  • FILTER
  • UNIQUE
  • SORT
  • XLOOKUP
  • SUMIFS
  • COUNTIFS
  • AGGREGATE
  • IF
  • IFERROR
  • GETPIVOTDATA

Web page: contextures.com

YouTube channel

# Jon Acampora #

excelcampus.com

Jon Acampora Profile 2019 Excel Campus

Top function according to Jon Acampora:

  • VLOOKUP
  • IF
  • INDEX
  • MATCH
  • FILTER
  • LAMBDA
  • CUBEVALUE

Web page: excelcampus.com

YouTube channel

# Ken Puls #

excelguru.ca

Ken Puls Excel Guru

Top function according to Ken Puls:

  • SUM
  • COUNT
  • ROUND
  • IF
  • XLOOKUP
  • SUMIF
  • EOMONTH

Web page: excelguru.ca

# John MacDougall #

howtoexcel.org

John MacDougall

Top function according to John MacDougall :

  • XLOOKUP
  • SORT
  • FILTER
  • LET
  • LAMBDA

Web page: howtoexcel.org

YouTube channel

# Oz du Soleil #

ozdusoleil.com

Oz du Soleil

Top function according to Oz du Soleil:

  • COUNTA
  • RANDARRAY
  • IF
  • XLOOKUP
  • COUNTIFS
  • SUMIFS
  • TEXTJOIN

Web page: ozdusoleil.com

YouTube channel

# John Michaloudis #

myexcelonline.com

John Michaloudis

Top function according to John Michaloudis:

  • SUMPRODUCT
  • XLOOKUP
  • DATEDIF
  • RANDBETWEEN
  • MATCH
  • LAMBDA
  • FILTER

Web page: myexcelonline.com

YouTube channel

# Sumit Bansal #

trumpexcel.com

Sumit Bansal šŸ“ŠšŸ“ˆ (@TrumpExcel) | Twitter

Top function according to Sumit Bansal:

  • VLOOKUP
  • XLOOKUP
  • FILTER
  • SORTBY
  • TEXT
  • FIND/SEARCH
  • IF
  • IFS
  • SUMPRODUCT

Web page: trumpexcel.com

YouTube channel

# Alan Murray #

computergaga.com

Alan Murray

Top function according to Alan Murray:

  • SUM
  • INDEX
  • IF
  • MATCH
  • SUMPRODUCT
  • FILTER
  • SWITCH

Web page: computergaga.com

YouTube channel

# Liam Bastick #

sumproduct.com

Excel Nerds Unite | Vena Liam Bastick

Top function according to Liam Bastick:

  • IF
  • SUM
  • SUMPRODUCT
  • OFFSET
  • LAMBDA
  • SORT
  • UNIQUE
  • EOMONTH
  • INDEX
  • MATCH

Web page: sumproduct.com

# Mark Proctor #

exceloffthegrid.com

Mark Proctor

Top function according to Mark Proctor:

  • CUBEVALUE
  • INDEX
  • XMATCH
  • SUM
  • IF
  • UNIQUE
  • SORT

Web page: exceloffthegrid.com

YouTube channel

# Istvan Vozar #

excelkid.com

Istvan Voza excelkid

Top function according to Istvan Vozar:

  • XLOOKUP
  • CHOOSE
  • TEXTJOIN
  • IFS
  • IFNA
  • COUNTIFS
  • SUMIFS

Web page: excelkid.com

# David Abiola #

exceljetconsult.com.ng

Abiola David Excel Jet Consult - YouTube

Top function according to David Abiola:

  • INDEX
  • MATCH
  • IF
  • SUMIFS
  • VLOOKUP
  • FILTER
  • LET
  • LAMBDA

Web page: exceljetconsult.com.ng

# Dinesh Takyar #

exceltrainingvideos.com

Dinesh Kumar Takyar

Top function according to Dinesh Takyar:

  • IF
  • VLOOKUP
  • XLOOKUP
  • SUMIF
  • SUMIFS
  • COUNTIF
  • COUNTIFS
  • SORT
  • FILTER
  • UNIQUE
  • PV

Web page: exceltrainingvideos.com

YouTube channel

# Radu Meghes #

excelexplained.com

Radu Meghes ā€“ Medium

Top function according to Radu Meghes:

  • IF
  • AND
  • OR
  • SUMPRODUCT
  • INDEX
  • MATCH
  • INDIRECT
  • CHOOSE
  • VLOOKUP
  • COUNTIFS

Web page: excelexplained.com

# Ben Currier #

excelexposure.com

Ben Currier

Top function according to Ben Currier:

  • XLOOKUP
  • INDEX
  • MATCH
  • TEXT
  • SUMIFS
  • IFERROR
  • CONCATENATE
  • COOUNTIFS
  • SUMPRODUCT
  • TODAY

Web page: excelexposure.com

YouTube channel

# Jon Peltier #

peltiertech.com

Jon Peltier (Jon Peltier)

Top function according to Jon Peltier:

  • SERIES
  • INDEX
  • OFFSET
  • IFS
  • SUMIFS
  • AGGREGATE
  • FILTER
  • SORT
  • LET
  • LAMBDA

Web page: peltiertech.com

# Dinesh Natarajan Mohan #

indzara.com

Dinesh Natarajan Mohan

Top function according to Dinesh Natarajan Mohan:

  • INDEX
  • MATCH
  • SUMPRODUCT
  • COUNTIFS
  • SUMIFS
  • IF
  • IFERROR
  • OFFSET
  • EOMONTH
  • TODAY

Web page: indzara.com

YouTube channel

# Robert Mundigl #

clearlyandsimply.com

Robert Mundigl

Top function according to Robert Mundigl:

  • SUMPRODUCT
  • INDEX
  • MATCH
  • SUMIFS
  • SUBTOTAL
  • UNIQUE
  • XLOOKUP
  • SORTBY
  • FILTER

Web page: clearlyandsimply.com

# Ryan Wells #

wellsr.com

Ryan Wells (@ryanwellsr) | Twitter

Top function according to Ryan Wells:

  • IF
  • CONCATENATE
  • MID
  • SUBSTITUTE
  • SORT
  • UNIQUE

Web page: wellsr.com

# Kasper Langmann #

spreadsheeto.com

Kasper Langmann

Top function according to Kasper Langmann :

  • IF
  • FILTER
  • INDEX
  • MATCH
  • XLOOKUP
  • SUMIF
  • MID
  • INDIRECT

Web page: spreadsheeto.com

# Jacob Shimota #

excelexercises.com

Jake Shimota

Top function according to Jacob Shimota:

  • IF
  • XLOOKUP
  • CONCAT
  • COUNTIFS
  • SUMIFS
  • LEFT/RIGHT
  • MINIFS/MAXIFS

Web page: excelexercises.com

# J.A. Gomez #

powerspreadsheets.com

J.A. Gomez

Top function according to J.A. Gomez:

  • FILTER
  • XLOOKUP
  • IF
  • SUMIFS
  • SUMPRODUCT
  • CHOOSE
  • TEXT

Web page: powerspreadsheets.com

# Petros Chatzipantazis #

spreadsheet1.com

Petros Chatzipantazis

Top function according to Petros Chatzipantazis :

  • GETPIVOTDATA
  • IF
  • INDEX
  • MATCH
  • MAX
  • MID
  • OFFSET
  • SUMIF
  • XLOOKUP

Web page: spreadsheet1.com

YouTube channel

# Jeff Robson #

accessanalytic.com.au

Jeff Robson

Top function according to Jeff Robson:

  • XLOOKUP
  • INDEX
  • MATCH
  • SUMIFS
  • SEQUENCE
  • SUMPRODUCT
  • INDIRECT
  • OFFSET

Web page: accessanalytic.com.au

#Nick Weisenberger#

excelspreadsheetshelp.blogspot.com

Nick Weisenberger - YouTube

Top function according to Nick Weisenberger:

  • SUM
  • AVERAGE
  • VLOOKUP
  • SUMIF
  • COUNTIF
  • IF
  • RANK
  • COUNTA
  • VALUE

Web page: excelspreadsheetshelp.blogspot.com

ANY COMMENTS?

Now Iā€™d like to hear from you:

Which kind of function is your TOP in Excel?

Do you use XLOOKUP OR UNIQUE?

Leave a comment below right now.

4 Comments

  1. Peter Bartholomew

    It is an interesting time for such a survey. The choice of functions almost provides a snapshot of the extent to which each of the experts has made the move from traditional spreadsheets to the more programmatic paradigm offered by 365. I find it surprising that VLOOKUP, SUMPRODUCT and CONCATENATE still exist in the important category.

    For me, the majority of formulae are built using LET, though one could argue that it provides the framework rather than the content of the formula.

    How soon before we see the Lambda helper functions such a SCAN or MAKEARRAY hitting the top slot?

Leave a Comment

Your email address will not be published. Required fields are marked *

Copy link
Powered by Social Snap