Log in
x
or
x
x
Register
x

or

Excel Tips: Calculation & Formulas > Math Functions

ABS Function

How to calculate the absolute difference between two values/times in Excel?

How to get the opposite of a ABS value in Excel?

Round Function

How to avoid rounding errors while calculating in Excel?

How to limit number of decimal places in formula in Excel?

How to remove digits after decimal in Excel?

How to round / round up / round down a range of cell numbers in Excel?

How to round / round up / round down time to nearest quarter / half hour in Excel?

How to round a range of cells in Excel?

How to round date to nearest month in Excel?

How to round date to previous or next specific weekday in Excel?

How to round number to nearest 5/10/50/100 in Excel?

How to round number up or down in Excel?

How to round numbers (up/down) to hundreds, thousands, or millions in Excel?

How to round numbers to nearest hundred / thousand / million in Excel?

How to round percentage values to two decimal places in Excel?

How to round prices to x.99 in Excel?

How to round range of numbers to even in Excel?

How to round then sum values by one formula in Excel?

How to round time to nearest hour/minute/second in Excel?

How to round to nearest 1000s/100s/10s/1s/0.1s numbers in Excel?

How to round to nearest even or odd number in Excel?

How to round values before summing in Excel?

SQRT Function

How to quickly calculate the square root of a value in Excel? 

SUM Function

Sum Across Sheets

How to create 3D reference to sum same range across multiple sheets in Excel?

How to sum same cell in multiple sheets in Excel?

How to sum values in same column across multiple sheets?

How to summarize data from worksheets / workbooks into one worksheet?

How to vlookup across multiple sheets and sum results in Excel?

Sum Excluding Cells

How to exclude cells in a column from sum in Excel?

How to quickly sum a column cells ignore #N/A errors in Excel?

How to quickly sum every other or nth row/column in Excel?

How to sum entire column except header/first row in Excel?

How to sum every n rows down in Excel?

How to sum range of cells ignoring errors in Excel?

How to sum values without or exclude subtotals in Excel?

How to sum values without or with n/a in Excel?

Sum until meeting condition

How to sum a column until a condition is met in adjacent column in Excel?

How to sum cell values in a column until blank cell reached?

How to sum column values until next blank cell in Excel?

How to sum numbers until a certain value is reached in adjacent cell in Excel?

Sum Visible Cell Only

How to count / sum cells based on filter with criteria in Excel?

How to quickly sum values excluding hidden columns in Excel?

How to sum only filtered or visible cells in Excel?

Sum with Criteria

How to count / sum cells based on the font colors in Excel?

How to count / sum odd / even numbers or rows in Excel?

How to count / sum only positive or negative numbers in Excel?

How to count / sum strikethrough cells in Excel?

How to count and sum cells based on background color in Excel?

How to count or sum cells based on cell color in Google sheet?

How to count/sum cells by colors with conditional formatting in Excel?

How to count/sum the cells greater than but less than a number?

How to quickly sum hourly data to daily in Excel?

How to sum / average ignore negative values in Excel?

How to sum / count bold numbers in a range of cells in Excel?

How to sum / count checked checkboxes in Excel?

How to sum based on column and row criteria in Excel?

How to sum cells if the corresponding string is in a certain length?

How to sum cells when value changes in another column?

How to sum corresponding values with same date in Excel?

How to sum data by weekday/month/quarter/year in Excel?

How to sum multiple columns based on single criteria in Excel?

How to sum numbers in brackets only in Excel?

How to sum numbers of last 7 or 30 days including TODAY in Excel?

How to sum only whole numbers in Excel?

How to sum or average values if dates in adjacent cells equal to specified month in Excel?

How to sum values based on criteria in another column in Excel?

How to sum values based on month and year in Excel?

How to sum values based on selection of drop-down list in Excel?

How to sum values based on text criteria in Excel?

How to sum values between two dates range in Excel?

How to sum values by group in Excel?

How to use HLOOKUP to sum a range of values in Excel?

How to use vlookup and sum in Excel?

How to vlookup across multiple sheets and sum results in Excel?

Others

How to AutoSum multiple rows/columns/worksheets in Excel?

How to calculate cumulative sum / running total of a column in Excel?

How to calculate running total /average in Excel?

How to correctly sum numbers with units in a range in Excel?

How to keep running total in one or a single cell in Excel?

How to quickly sum up data of each column in Excel?

How to round then sum values by one formula in Excel?

How to round values before summing in Excel?

How to sum a specified row or column in a named range in Excel?

How to sum all digits in a number in Excel?

How to sum cell values with case sensitive in Excel?

How to sum cells with text and numbers in Excel?

How to sum diagonal of a range in Excel?

How to sum first digit of each cell only in Excel?

How to sum largest or smallest 3 values in a list of Excel?

How to sum numbers from 1 to n in Excel worksheet?

How to sum numbers regardless of sign in Excel?

How to sum numbers with commas in a single Excel cell?

How to sum or adding numbers in a single cell in Excel?

How to sum or average unique values only in Excel?

How to sum or count first n values in an Excel column or row?

How to sum the absolute values in Excel?

How to sum time and format as hours, minutes or seconds in Excel?

How to sum up values from textboxes?

SUMIF Function

How to sumif adjacent cell is equal, blank or containing text in Excel?

How to sumif based on partial match in Excel?

How to sumif cell values between two given dates in Google sheets?

How to sumif cells begin with specific number or text in Excel?

How to sumif cells if contains part of text string in Goolge sheets?

How to sumif cells not equal to a specific value in Excel?

How to sumif date is less/greater than today in Excel?

How to sumif with 3d reference to sum across tabs based on criteria in Excel?

How to sumif with multiple criteria in one column?

How to sumif with numbers stored as text in Excel?

How to sumif with one or more criteria in Excel?

SUMPRODUCT Function

How to multiply two columns and then sum in Excel?

How to quickly calculate the square root of a value in Excel?