101 Best Excel Functions compatible with Excel 2019
Categories- Function Category 📊StatisticalOperation Type 🔧AggregationVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢2Pros ✅Easy Conditional Counting, Flexible Criteria, Simple To Use and EfficientCons ❌Limited To Single Condition, Case Sensitive and Limited Criteria Options
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢3Pros ✅Flexible Matching, Works With INDEX, Versatile Search and FastCons ❌Requires Sorted Data, Complex Syntax and Requires Exact Matches
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢3Pros ✅Precise Text Extraction & Simple ParametersCons ❌Fixed Length Extraction Only & Starts Counting At 1
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢3Pros ✅Statistical Accuracy, Trend Analysis, Professional, Scientific Prediction and Based On Historical DataCons ❌Assumes Linear Relationship, Complex Setup and Sensitive To Outliers
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016, Excel 2013, Microsoft 365 and Excel OnlineRequired Arguments Count 🔢4Pros ✅Powerful Search Capability, Flexible Matching, Powerful Search and Common In BusinessCons ❌Left To Right Only, Can Be Slow With Large Datasets, Right-Only Search and Can Be Slow
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢2Pros ✅Easy To Use, Versatile For Filtering Sums and Clear SyntaxCons ❌Limited To Single Condition & Can Be Slow With Large Datasets
- Function Category 📊Date & TimeOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Consistent Week Numbering & Multiple Systems SupportCons ❌Different Week Counting Systems & Regional Variations
- Function Category 📊MathematicalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢~Pros ✅No Arguments Needed & Dynamic UpdatesCons ❌Not Truly Random & Changes Frequently
- Function Category 📊TextOperation Type 🔧ConversionVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Unique Conversion, Educational Value and InterestingCons ❌Limited Practical Use & Maximum Value Limit
- Function Category 📊DatabaseOperation Type 🔧AggregationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢3Pros ✅Powerful Database Calculations & Complex Criteria SupportCons ❌Complicated Syntax & Requires Database Structure
- Function Category 📊Date & TimeOperation Type 🔧ConversionVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Simple Date Conversion & Format FlexibleCons ❌Region Format Dependent & Text Must Be Recognizable Date
- Function Category 📊TextOperation Type 🔧ManipulationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢2Pros ✅Case Insensitive, Flexible Search Options and Returns PositionCons ❌Cannot Handle Complex Patterns & Limited Functionality
- Function Category 📊DatabaseOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 97Required Arguments Count 🔢3Pros ✅Powerful Database Functionality, Specific Criteria Handling, Powerful For Database Operations and Flexible CriteriaCons ❌Complex Syntax, Limited Visibility and Limited To Database Ranges
- Function Category 📊DatabaseOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 97Required Arguments Count 🔢3Pros ✅Database Specific Operations, Criteria Flexibility, Precise Database Filtering and Reliable ResultsCons ❌Requires Database Structure, Limited Use Cases, Requires Structured Data and Complex Syntax
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Advanced Statistics, Precise Calculations and ProfessionalCons ❌Complex For Beginners & Specific Use Case
- Function Category 📊DatabaseOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 97Required Arguments Count 🔢3Pros ✅Efficient With Large Datasets, Reliable Results, Excellent For Database Analysis and Flexible CriteriaCons ❌Complex Syntax, Database Structure Dependent and Limited To Database Ranges
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 97Required Arguments Count 🔢3Pros ✅Statistical Accuracy, Database Filtering, Accurate Statistical Measure and Database FriendlyCons ❌Complex Implementation, Limited Use Cases, Limited Application and Complex Setup
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢4Pros ✅Flexible Horizontal Search & Good For Wide DatasetsCons ❌Limited To Horizontal Data & Less Common Than VLOOKUP
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢2Pros ✅Simple To Understand & Works With Sorted DataCons ❌Limited To One-Way Lookups & Requires Sorted Data
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢3Pros ✅Flexible Range Selection & Dynamic ReferencesCons ❌Volatile Calculation & Complex Syntax
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 97Required Arguments Count 🔢3Pros ✅Statistical Precision, Database Integration, Accurate Statistical Analysis and Database CompatibleCons ❌Limited Audience, Complex Syntax, Complex For Beginners and Limited Use Cases
- Function Category 📊Lookup & ReferenceOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019, Excel 2016 and Excel 2013Required Arguments Count 🔢1Pros ✅Flexible Referencing & Dynamic Range SelectionCons ❌Performance Intensive & Complex Syntax
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 97Required Arguments Count 🔢3Pros ✅Population Analysis, Database Integration, Population Standard Deviation and Database CompatibleCons ❌Specialized Usage, Complex Syntax, Complex For Beginners and Specific Use Case
- Function Category 📊StatisticalOperation Type 🔧CalculationVersion Compatibility 💻Excel 2019 & Excel 97Required Arguments Count 🔢3Pros ✅Population Calculations, Database Integration, Population Variance Calculation and Database CompatibleCons ❌Highly Specialized, Complex Setup, Specific Use Case and Complex Syntax
- Function Category 📊DatabaseOperation Type 🔧RetrievalVersion Compatibility 💻Excel 2019 & Excel 97Required Arguments Count 🔢3Pros ✅Precise Data Extraction, Criteria Filtering, Precise Single Value Extraction and ReliableCons ❌Single Result Only, Complex Setup and Returns Error If Multiple Matches
Facts about Best Excel Functions compatible with Excel 2019
- COUNTIF belongs to the Statistical category. COUNTIF performs Aggregation operations. The Excel versions supporting COUNTIF are Excel 2019,Excel 2016,Excel 2013,Microsoft 365. COUNTIF needs 2 required arguments
- MATCH belongs to the Lookup & Reference category. MATCH performs Retrieval operations. The Excel versions supporting MATCH are Excel 2019,Excel 2016,Excel 2013,Microsoft 365. MATCH needs 3 required arguments
- MID belongs to the Text category. MID performs Manipulation operations. The Excel versions supporting MID are Excel 2019,Excel 2016. MID needs 3 required arguments
- FORECAST belongs to the Statistical category. FORECAST performs Calculation operations. The Excel versions supporting FORECAST are Excel 2019,Excel 2016. FORECAST needs 3 required arguments
- VLOOKUP belongs to the Lookup & Reference category. VLOOKUP performs Retrieval operations. The Excel versions supporting VLOOKUP are Excel 2019,Excel 2016,Excel 2013,Microsoft 365. VLOOKUP needs 4 required arguments
- SUMIF belongs to the Mathematical category. SUMIF performs Calculation operations. The Excel versions supporting SUMIF are Excel 2019,Excel 2016. SUMIF needs 2 required arguments
- WEEKNUM belongs to the Date & Time category. WEEKNUM performs Calculation operations. The Excel versions supporting WEEKNUM are Excel 2019,Excel 2016. WEEKNUM needs 1 required arguments
- RAND belongs to the Mathematical category. RAND performs Calculation operations. The Excel versions supporting RAND are Excel 2019,Excel 2016. RAND needs required arguments
- ROMAN belongs to the Text category. ROMAN performs Conversion operations. The Excel versions supporting ROMAN are Excel 2019,Excel 2016. ROMAN needs 1 required arguments
- DSUM belongs to the Database category. DSUM performs Aggregation operations. The Excel versions supporting DSUM are Excel 2019,Excel 2016. DSUM needs 3 required arguments
- DATEVALUE belongs to the Date & Time category. DATEVALUE performs Conversion operations. The Excel versions supporting DATEVALUE are Excel 2019,Excel 2016. DATEVALUE needs 1 required arguments
- SEARCH belongs to the Text category. SEARCH performs Manipulation operations. The Excel versions supporting SEARCH are Excel 2019,Excel 2016. SEARCH needs 2 required arguments
- DCOUNT belongs to the Database category. DCOUNT performs Calculation operations. The Excel versions supporting DCOUNT are Excel 2019,Excel 97. DCOUNT needs 3 required arguments
- DMIN belongs to the Database category. DMIN performs Calculation operations. The Excel versions supporting DMIN are Excel 2019,Excel 97. DMIN needs 3 required arguments
- KURT belongs to the Statistical category. KURT performs Calculation operations. The Excel versions supporting KURT are Excel 2019,Excel 2016. KURT needs 1 required arguments
- DMAX belongs to the Database category. DMAX performs Calculation operations. The Excel versions supporting DMAX are Excel 2019,Excel 97. DMAX needs 3 required arguments
- DSTDEV belongs to the Statistical category. DSTDEV performs Calculation operations. The Excel versions supporting DSTDEV are Excel 2019,Excel 97. DSTDEV needs 3 required arguments
- HLOOKUP belongs to the Lookup & Reference category. HLOOKUP performs Retrieval operations. The Excel versions supporting HLOOKUP are Excel 2019,Excel 2016. HLOOKUP needs 4 required arguments
- LOOKUP belongs to the Lookup & Reference category. LOOKUP performs Retrieval operations. The Excel versions supporting LOOKUP are Excel 2019,Excel 2016. LOOKUP needs 2 required arguments
- OFFSET belongs to the Lookup & Reference category. OFFSET performs Retrieval operations. The Excel versions supporting OFFSET are Excel 2019,Excel 2016. OFFSET needs 3 required arguments
- DVAR belongs to the Statistical category. DVAR performs Calculation operations. The Excel versions supporting DVAR are Excel 2019,Excel 97. DVAR needs 3 required arguments
- INDIRECT belongs to the Lookup & Reference category. INDIRECT performs Retrieval operations. The Excel versions supporting INDIRECT are Excel 2019,Excel 2016. INDIRECT needs 1 required arguments
- DSTDEVP belongs to the Statistical category. DSTDEVP performs Calculation operations. The Excel versions supporting DSTDEVP are Excel 2019,Excel 97. DSTDEVP needs 3 required arguments
- DVARP belongs to the Statistical category. DVARP performs Calculation operations. The Excel versions supporting DVARP are Excel 2019,Excel 97. DVARP needs 3 required arguments
- DGET belongs to the Database category. DGET performs Retrieval operations. The Excel versions supporting DGET are Excel 2019,Excel 97. DGET needs 3 required arguments