Skip to content
ExcelSirJi
  • Home
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
ExcelSirJi
EXCEL FUNCTION – AVERAGEIFS
Excel Formula Tips

EXCEL FUNCTION – AVERAGEIFS

ByPradeep Kumar

AVERAGEIFS function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.

Read More EXCEL FUNCTION – AVERAGEIFSContinue

EXCEL FUNCTION – AVERAGEIF
Excel Formula Tips

EXCEL FUNCTION – AVERAGEIF

ByPradeep Kumar

AVERAGEIF function is used to get the “average” of values for matching criteria across range. Average = Sum of all values / number of items.

Read More EXCEL FUNCTION – AVERAGEIFContinue

EXCEL FUNCTION – AVERAGE
Excel Formula Tips

EXCEL FUNCTION – AVERAGE

ByPradeep Kumar

AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items.

Read More EXCEL FUNCTION – AVERAGEContinue

EXCEL FUNCTION – RANK
Excel Formula Tips

EXCEL FUNCTION – RANK

ByPradeep Kumar

RANK function performs the Ranking in a range or list of numbers. Function returns the rank position and can assigned as highest or lowest value as 1st Rank

Read More EXCEL FUNCTION – RANKContinue

EXCEL FUNCTION – SUMPRODUCT
Excel Formula Tips

EXCEL FUNCTION – SUMPRODUCT

ByPradeep Kumar

SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.

Read More EXCEL FUNCTION – SUMPRODUCTContinue

EXCEL FUNCTION – ROUND
Excel Formula Tips

EXCEL FUNCTION – ROUND

ByPradeep Kumar

ROUND function rounds the number value to nearest digit mentioned in argument.

ROUND function has two required arguments i.e. number and num_digits

Read More EXCEL FUNCTION – ROUNDContinue

EXCEL FUNCTION – MATCH
Excel Formula Tips

EXCEL FUNCTION – MATCH

ByPradeep Kumar

MATCH function performs lookup for a value in a range and returns its position sequence number as output. It has two required and one optional arguments

Read More EXCEL FUNCTION – MATCHContinue

EXCEL FUNCTION – MIN
Excel Formula Tips

EXCEL FUNCTION – MIN

ByPradeep Kumar

MIN function is used to get the smallest number in range or list of values.MIN function has one required i.e. number1 and optional argument i.e. [number2]

Read More EXCEL FUNCTION – MINContinue

EXCEL FUNCTION – MAX
Excel Formula Tips

EXCEL FUNCTION – MAX

ByPradeep Kumar

MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1

Read More EXCEL FUNCTION – MAXContinue

EXCEL FUNCTION – MOD
Excel Formula Tips

EXCEL FUNCTION – MOD

ByPradeep Kumar

MOD function is used to get the remainder of number that is divided by divisor. MOD Function has two required arguments i.e. number and divisor.

Read More EXCEL FUNCTION – MODContinue

EXCEL FUNCTION – INT
Excel Formula Tips

EXCEL FUNCTION – INT

ByPradeep Kumar

INT function is used to round down the numeric value to nearest integer. INT Function has one required argument i.e. number.

Read More EXCEL FUNCTION – INTContinue

EXCEL FUNCTION – ROWS
Excel Formula Tips

EXCEL FUNCTION – ROWS

ByPradeep Kumar

ROWS function is used to get the total count of rows in an array or in cells range in an excel worksheet.

Read More EXCEL FUNCTION – ROWSContinue

EXCEL FUNCTION – ROW
Excel Formula Tips

EXCEL FUNCTION – ROW

ByPradeep Kumar

ROW function is used to get the row reference number of the excel worksheet. ROW Function has only one argument i.e. reference,

Read More EXCEL FUNCTION – ROWContinue

EXCEL FUNCTION – INDIRECT
Excel Formula Tips

EXCEL FUNCTION – INDIRECT

ByPradeep Kumar

INDIRECT function is used to convert the text/string into cell reference. Function provides output as the value of that cell reference.

Read More EXCEL FUNCTION – INDIRECTContinue

EXCEL FUNCTION – SUMIFS
Excel Formula Tips

EXCEL FUNCTION – SUMIFS

ByPradeep Kumar

SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments

Read More EXCEL FUNCTION – SUMIFSContinue

EXCEL FUNCTION – COUNTIFS
Excel Formula Tips

EXCEL FUNCTION – COUNTIFS

ByPradeep Kumar

COUNTIFS function is used to get the total count for number of times the various criteria across ranges are met.

Read More EXCEL FUNCTION – COUNTIFSContinue

EXCEL FUNCTION – SUMIF
Excel Formula Tips

EXCEL FUNCTION – SUMIF

ByPradeep Kumar

SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.

Read More EXCEL FUNCTION – SUMIFContinue

EXCEL FUNCTION – INDEX
Excel Formula Tips

EXCEL FUNCTION – INDEX

ByPradeep Kumar

INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.

Read More EXCEL FUNCTION – INDEXContinue

EXCEL FUNCTION – COLUMNS
Excel Formula Tips

EXCEL FUNCTION – COLUMNS

ByPradeep Kumar

COLUMNS function is used to get the total count of columns in an array or in cells range for excel worksheet.

Read More EXCEL FUNCTION – COLUMNSContinue

EXCEL FUNCTION – COLUMN
Excel Formula Tips

EXCEL FUNCTION – COLUMN

ByPradeep Kumar

COLUMN function is used to get the column reference number of the excel worksheet. COLUMN Function has only one argument.

Read More EXCEL FUNCTION – COLUMNContinue

EXCEL FUNCTION – TRIM
Excel Formula Tips

EXCEL FUNCTION – TRIM

ByPradeep Kumar

TRIM function is used to remove the additional spaces (i.e. spaces before/after/between the words) except for single space between words.

Read More EXCEL FUNCTION – TRIMContinue

Page navigation

Previous PagePrevious 1 2 3 4 … 7 Next PageNext
  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2022 ExcelSirJi

  • Home
  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
Search