Skip to content
- Excel SUM Not Working? Fix Common Formula ProblemsIf Excel SUM does not work, first check that the formula starts with an equals sign, covers the intended cells, and is…Errors & fixes
- Excel SUM Divided by Count: Calculate an AverageTo add a range in Excel and divide by the number of numeric cells, use =SUM(B2:B6)/COUNT(B2:B6) when the values are in B2:B6.…How-to basics
- Excel Sum by Color: How to Total Cells by Fill ColorExcel for Microsoft 365 does not include a built-in SUMBYCOLOR formula. The simplest dependable method is to filter the rows by fill…How-to basics
- Excel Sum Between Dates: SUMIFS Formulas and ExamplesIf dates are in A2:A100, amounts are in B2:B100, and the start and end dates are in E2 and F2, use =SUMIFS($B$2:$B$100,$A$2:$A$100,">="&E2,$A$2:$A$100,"="…Formulas & functions
- Excel Sum Based on Filter: Formulas for Visible RowsTo sum only the rows currently visible after filtering in Excel, use SUBTOTAL. With values in B2:B100, enter =SUBTOTAL(109,B2:B100); the total updates…Formulas & functions
- Excel Sum by Cell Color: Methods That Actually WorkExcel does not have a built-in SUMIF function that adds cells based on fill color. To total one color, filter the range…How-to basics
- Excel MAX IF: Find the Highest Number by ConditionTo find the largest number in Excel that meets a condition, use MAXIFS, such as =MAXIFS(C2:C7,B2:B7,"East"). If you mean the largest value…Formulas & functions
- Excel Max Cell Height: The 409-Point Row Height LimitIn Excel for Microsoft 365 on Windows, the maximum row height is 409 points, or about 5.68 inches (14.4 cm). A cell…How-to basics
- Excel MIN Without Blanks: What the Formula IgnoresIf your values are in A2:A10, use =MIN(A2:A10) to find the smallest number while ignoring blank cells. Excel’s MIN function already skips…Formulas & functions
- Large Excel File Won’t Open? Causes and Practical FixesIf a large Excel file won’t open, first copy it to a local drive, close other programs, and try opening Excel in…How-to basics
- Excel Modify Drop-Down Lists: Steps, Tips and FixesTo modify an Excel drop-down list, select a cell that uses it, open Data > Data Validation, and edit the entries in…How-to basics
- Excel Mode With Text: Find the Most Frequent Text ValueExcel’s MODE.SNGL and MODE.MULT functions work with numbers, not words. To find the most frequent text value, count each entry with COUNTIF,…How-to basics
- Excel MODE.MULT: Find Multiple Modes in a Data SetYes. In Microsoft 365 Excel for Windows, use MODE.MULT to return every value tied for the highest frequency in a data set.…How-to basics
- Excel Pivot Table Mode: Find the Most Common ValueTo find a mode with an Excel PivotTable, put the field you want to analyze in both Rows and Values, set the…Charts & pivot tables
- Roundup Excel Without Decimals: 10 Reliable MethodsTo round a value in Excel to the nearest whole number, use =ROUND(A2,0); to make every positive value round upward, use =ROUNDUP(A2,0).…How-to basics
- ROUNDUP Excel Cell Reference: 10 Useful Formula PatternsWith 12.31 in A2, enter =ROUNDUP(A2,0) to return 13; the formula reads the number from a cell and rounds it away from…Formulas & functions
- Roundup Excel Cell Values: 10 Ways to Round NumbersTo round a number up to the next whole number in Excel, with the value in A2, enter =ROUNDUP(A2,0); for example, 2.31…Formulas & functions
- Round Excel Without Decimals: Formula or Formatting?To round a value in Excel to the nearest whole number, use =ROUND(A1,0) when the value is in A1. If you only…Formulas & functions
- Excel Last Day of Month: Formula and ExamplesTo return the last day of the month for a date in Excel, use =EOMONTH(A2,0), where A2 contains a valid Excel date.…Formulas & functions
- Excel ROUND: Does It Round Positive or Negative Numbers?Excel’s ROUND function rounds both positive and negative numbers to the nearest value at the specified decimal place. When the digit being…Formulas & functions
- Round Excel Cell Values: Formulas and Display OptionsTo round a number in an Excel cell and change the value used in calculations, use the ROUND function: with the number…Formulas & functions
- Excel Day Timeline: Build a Daily Schedule or Date FilterAn Excel day timeline can mean either a daily schedule laid out across worksheet columns or a PivotTable Timeline control used to…Formulas & functions
- Excel Day School? Meaning and How to Identify One“Excel day school” does not identify one universally recognized school: it may refer to a particular school named Excel, or to a…How-to basics
- Excel Days, Hours, and Minutes: Format DurationsTo show an elapsed time in Excel as days, hours, and minutes, keep the duration as a number and either format it…How-to basics
- Excel Day of Week from Date: Formulas and FormattingIf your date is in A2, enter =TEXT(A2,"dddd") to show its full weekday name; for example, an actual date of April 15,…Formulas & functions
- Excel Day Number: Serial Dates, Day of Month and YearIf A2 contains a valid Excel date such as June 15, 2024, and you want its day of the month, enter =DAY(A2);…How-to basics
- Excel Day Name from Date: Formulas, Formats, and FixesTo show the day name for a date in Excel, enter =TEXT(A2,"dddd") in another cell, assuming A2 contains a valid Excel date.…Formulas & functions
- Excel Not Recognizing Dates? Fix Text and Format IssuesIf Excel is not recognizing dates, check whether the cell contains a real date value or text: apply Home > Number Format…Errors & fixes
- Excel Day Month Year Format: Dates That Display ClearlyTo display Excel dates as day, month, year, select the date cells, press Ctrl+1, choose Custom, and enter dd/mm/yyyy for a numeric…How-to basics
- Excel Not Opening CSV Correctly? How to Fix ItIf Excel is not opening a CSV correctly, import it instead of double-clicking the file: in Excel for Microsoft 365 on Windows,…Errors & fixes