Blog

10 Excel formulas that helps you in any job (Part 1)

In our daily life, we always use excel to store and retrieve numerical data in a grid format of columns and rows.  Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. To maintain our work, we always need some formula to make us easier to keep it useful. Here is some important formula that we must use to any job-

  1. SUM  formula
  2. COUNT formula
  3. COUNTA formula
  4. LEN function
  5. TRIM function
  6. Right, LEFT and MID function
  7. VLOOKUP
  8. If Statements
  9. SUMIF, COUNTIF and AVERAGEIF
  10. CONCATENATE function

Sum Formula

The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together

Formula:=SUM(5,5) or =SUM(A1,B1) or =SUM(A1,B5)

The Above shows you different examples. You can have numbers in there separated by commas and it will add them together for you. You can have cell references and as long as numbers in those cells it will add them together for you, or you can have a range of cells with a colon in between the 2 cells, and it will add the numbers in all the cells in the range.

KeyBoard Shortcuts:

ALT+=(Equal to sign): The Shortcut automatically selects the range of cells above the formula up to an empty cell. If used after applying a filter on a column, this shortcut will give the subtotal of the filtered values for that column.

Sum formula

COUNT Formula:

The count formula counts the number of cells in a range that have numbers in them. This formula only works with numbers, though, It only counts the cell when there are numbers.

Formula: =Count(A1:A10)

COUNTA Formula:

Counts the number of non-empty cells in a range. It will count cells that have numbers and or any characters in them.

Formula: =COUNTA(A1:A10)

It counts the number of empty cells no matter the data type.

COUNTA excel formula

LEN Function:

The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.

Formula: =LEN(A1)

Len excel function

Notice the difference in the formula results: 10 characters without spaces in between the words, 12 with spaces between the words, 12 with spaces between the words.

In the next blog, we will discuss the remaining formula for you. So keep looking. Till then.

~TechCare

Share this:

Leave a Reply

GO TOP