Excel Formulas - Add Category
Master the essentials of data calculation with our step-by-step guide on how to add an Excel formula. Learn to streamline your workflow, use popular functions, and automate tasks to save time and increase accuracy in your spreadsheets today.
Excel Formula to Sum Two Columns Based on Criteria
Learn how to easily add two columns in Excel based on specific criteria using powerful formulas like SUMPRODUCT and SUMIFS.
Excel Formulas to Sum Numbers with Text Units
Learn how to sum numbers with text units (like "kg" or "pcs") in Excel using a simple formula with SUMPRODUCT and SUBSTITUTE.
Excel Formula to Add Standard Hours and Overtime Minutes
Learn the simple Excel formula to add standard hours and overtime minutes together for accurate payroll and timesheet calculations.
How to Add a Percentage to a Number in Excel
Learn the simple Excel formula to quickly add a percentage increase to any original value, complete with easy, step-by-step examples.
Excel Formula to Sum Only Visible Rows and Columns
Master the Excel formula to sum filtered rows while excluding hidden columns. Learn how to calculate only visible data in your spreadsheets.
Excel Formulas for Adding Dynamic Arrays with Spill Ranges
Learn how to add dynamic arrays in Excel using the spill operator (#) to create formulas that automatically expand and update with your data.
How to Add Hexadecimal Codes and Decimal Numbers in Excel
Learn how to use Excel's HEX2DEC and DEC2HEX formulas to quickly add hexadecimal codes with decimal numbers in your spreadsheets.
Excel WORKDAY Formula for Adding Business Days with Variable Holidays
Master the Excel WORKDAY formula to easily add business days to any date while excluding weekends and custom, variable holidays.
Excel Formula to Sum Roman Numerals and Arabic Numbers
Learn how to easily add Roman numerals and Arabic digits in Excel using a simple formula with the ARABIC and ROMAN functions.
Excel Formulas for Combining Latitude and Longitude Coordinates
Easily combine latitude and longitude coordinates into a single Excel cell using simple formulas like CONCATENATE or the ampersand (&) operator.
Excel Formula to Sum Merged and Unmerged Cell Ranges
Master the Excel formulas needed to seamlessly add merged cell values with unmerged cell ranges and solve calculation errors with this quick guide.
How to Convert Base Prices Using Currency Exchange Rates in Excel
Learn how to write an Excel formula to multiply base prices by currency exchange rates for quick and accurate multi-currency calculations.
Excel Formulas for Adding Specific Time Intervals to Date Values
Learn how to use Excel formulas to easily add specific time intervals-like days, hours, months, or years-to any date value.
Excel Formulas for Calculating Subtotals and Grand Totals
Learn how to use the Excel SUBTOTAL formula to quickly calculate group subtotals and an accurate grand total without double-counting.
Excel Formula to Convert and Add Fractional Inches and Decimal Feet
Learn how to use an Excel formula to easily convert and add fractional inches with decimal feet for precise measurement calculations.
Excel SUMIFS Formula: Summing Cells with Multiple Criteria
Learn how to use the Excel SUMIFS formula to quickly add values that meet multiple criteria with this easy, step-by-step guide.
How to Add a Percentage to Price in Excel
Easily add a percentage to an existing price in Excel. Learn the simple formula and step-by-step method to calculate price increases and markups fast.
Excel Formula Guide: Adding Hours Beyond the 24-Hour Limit
Learn how to sum and display total times exceeding 24 hours in Excel using a simple formula and the custom `[h]:mm` formatting trick.
Excel Formulas for Adding a Prefix to Non-Empty Cells
Easily add a prefix to non-empty cells in Excel using a simple IF formula while keeping blank cells empty. Learn the quick step-by-step method.
How to Add Leading Zeros in Excel to Match a Fixed Length
Learn how to use simple Excel formulas like the TEXT function to easily add leading zeros and format numbers to a specific fixed length.
How to Add Days to a Date Excluding Weekends and Holidays in Excel
Learn how to use the Excel WORKDAY function to easily add days to a date while automatically excluding weekends and custom holidays.
How to Add a Suffix to Cells Containing Specific Text in Excel
Learn how to use an Excel formula to automatically add a suffix to cells containing specific text or keywords in this quick step-by-step guide.
How to Add Months to Dates in Excel Based on Subscription Cycles
Easily calculate subscription renewal dates in Excel using the EDATE formula to add months based on monthly, quarterly, or annual billing cycles.
Excel Formulas to Add Time Intervals to a List of Timestamps
Easily add hours, minutes, or seconds to a list of timestamps in Excel with this simple guide to quick and accurate time formulas.
Excel 3D Formula to Sum Data Across Multiple Sheets With the Same Layout
Learn how to use the Excel 3D SUM formula to easily add values across multiple worksheets with the exact same layout.
Excel Formulas to Add Tax to Price Based on Location Code
Learn how to use Excel formulas like VLOOKUP or XLOOKUP to automatically calculate and add tax to prices based on specific location codes.
Excel Formula to Sum Only Visible Rows in a Filtered Range
Learn how to use the Excel SUBTOTAL formula to sum only visible rows in a filtered range, easily ignoring hidden cells in your calculations.
Excel Formulas for Generating Dynamic Sequential Numbers in Lists
Learn how to automatically add sequential numbers to a dynamic Excel list using the SEQUENCE formula so your row numbers update instantly as data changes.
Excel Formulas to Combine Text Values with Commas
Learn how to use Excel's TEXTJOIN formula and other simple methods to easily combine text values from multiple cells separated by commas.
Excel Formulas to Sum Values While Ignoring Cell Errors
Learn how to easily sum values in Excel while ignoring cell errors like #N/A, #VALUE!, or #DIV/0! using the AGGREGATE and IFERROR formulas.