Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • 150 Keyboard Shortcuts
  • Contact

sum excel

  • Home
  •   »  
  • sum excel
Excel
Excel SUMIF Function

The SUMIF Function in Excel

The Sumif function in Excel is one of the easiest to learn, yet also extremely powerful. Very often in Excel, there are

Excel Functions Excel Math Functions
RANDBETWEEN – Excel Function

RANDBETWEEN – Excel Function

What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than

Excel Functions Excel Math Functions
RAND – Excel Function

RAND – Excel Function

What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother

Excel Functions Excel Math Functions
AVERAGE – Excel Function

AVERAGE – Excel Function

The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be

Excel Functions Excel Math Functions
SMALL – Excel Function

SMALL – Excel Function

What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()

Excel Functions Excel Math Functions
LARGE – Excel Function

LARGE – Excel Function

What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function

Excel Functions Excel Math Functions
COUNTIFS – Excel Function

COUNTIFS – Excel Function

What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:

Posts navigation

1 2 3 »
  • Articles
  • Excel Training Videos
  • Books on Excel & Data
  • 150 Keyboard Shortcuts in Excel (Windows)
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Excel Text Functions
    • Excel Math Functions
    • Excel Logical Functions
    • Excel Lookup and Reference Functions
Copyright ©2023 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com