Skip to content
Basic Excel Tutorial
  • Excel Tips
    • Pivot Table
    • Vlookup
    • Worksheet
    • Tips
  • Formula
    • Formula List
    • Find
    • Convert
  • Graphs and Charts
    • Graphs
    • Charts
    • Tables
  • Calculations
  • Formatting
    • Columns
    • Cells
    • Rows
  • VBA
    • Macros
  • Terms of Service

10 Best formulas in Excel

10 Best formulas in Excel

February 12, 2022March 18, 2020 by Amos Gikunda
10 Best formulas in Excel

Excel has provided a vast formula to perform different operations. 1. Sum Used for adding numbers Syntax Sum(Number 1, Number 2.,Number 9) or SUM( Starting location of data: Last location of data) Example sum(20,30,40) = 20+30+40 = 90 =SUM(A1:A8) = add all numbers updated in column A from row 1 to 8 =SUM(A1:B8) = add … Read more

Categories Formula List Tags 10 Best formulas in Excel, 10 important formulas in Excel
  • How to remove password protection in Excel
  • How to count without duplicates in Excel
  • Excel: How to put 0 in front of numbers
  • Excel Formula for IF with multiple conditions
  • How to merge Excel files into one
  • How to calculate years between two dates in Excel
  • How to graph three variables in Excel
  • Excel: How to remove last 4 characters
  • How to use date reminders in excel
  • How to remove the last four digits in Excel
  1. Admin on How to update excel to the latest versionMarch 26, 2021

    Can you please comment on the right page? Your comment is on https://basicexceltutorial.com/excel-tips/how-to-update-excel-to-the-latest-version

  2. Randy on How to update excel to the latest versionMarch 25, 2021

    your answer to "excel function count cells that contain dates" to use counta(a4:a9) only counts non blank cells. Even a…

Facebook

basicexceltutorial.com

Recent Posts

  • How to Stop Excel from Converting Certain Text Values to Dates
  • How to Display Milliseconds in Excel
  • How to Add Leading Zeroes to Existing Excel Values to Certain Length
  • Trick to Lock Row Height and Column Width in Excel
  • How to Print the Top Row or Column on Every Page in Excel
© 2022 Basic Excel Tutorial
 

Loading Comments...