## Excel Tips: Calculation & Formulas > Math Functions

### 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?