Scribd
Upload
44 views

SUM (Number1, (Number2), ) 2.: Sumif

The document provides summaries of 11 commonly used Excel formulae: SUM, SUMIF, AVERAGE, COUNT, COUNTA, IF, TRIM, MAX & MIN, INDEX & MATCH, CONCATENATE, PROPER, and IF STATEMENTS. SUM adds values, SUMIF sums values that meet criteria, AVERAGE calculates the average, COUNT counts numeric values, COUNTA counts all cell values, IF performs conditional tests, TRIM removes spaces, MAX & MIN find maximum and minimum values, INDEX & MATCH retrieve values based on row/column numbers, CONCATENATE combines text, PROPER formats text with proper case, and IF STATEMENTS outputs text based on conditional tests.

Uploaded by

Adeeba Fatima
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
44 views

SUM (Number1, (Number2), ) 2.: Sumif

The document provides summaries of 11 commonly used Excel formulae: SUM, SUMIF, AVERAGE, COUNT, COUNTA, IF, TRIM, MAX & MIN, INDEX & MATCH, CONCATENATE, PROPER, and IF STATEMENTS. SUM adds values, SUMIF sums values that meet criteria, AVERAGE calculates the average, COUNT counts numeric values, COUNTA counts all cell values, IF performs conditional tests, TRIM removes spaces, MAX & MIN find maximum and minimum values, INDEX & MATCH retrieve values based on row/column numbers, CONCATENATE combines text, PROPER formats text with proper case, and IF STATEMENTS outputs text based on conditional tests.

Uploaded by

Adeeba Fatima
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Formulae’s:

1. SUM

The SUM function is the first must-know formula in Excel. It usually aggregates
values from a selection of columns or rows from your selected range.

=SUM(number1, [number2], …)

2.  SUMIF

This  function to sum the values in a range that meet criteria that you specify. For
example, suppose that in a column that contains numbers, you want to sum only the
values that are larger than 5. You can use the following
formula: =SUMIF(B2:B25,">5")

2. AVERAGE

The AVERAGE function should remind you of simple averages of data such as the
average number of shareholders in a given shareholding pool.

=AVERAGE(number1, [number2], …)

3. COUNT

The COUNT function counts all cells in a given range that contains only numeric
values.

=COUNT(value1, [value2], …)

4. COUNTA

Like the COUNT function, COUNTA counts all cells in a given rage. However, it counts
all cells regardless of type. That is, unlike COUNT that relies on only numerics, it also
counts dates, times, strings, logical values, errors, empty string, or text.

=COUNTA(value1, [value2], …)

5. IF

The IF function is often used when you want to sort your data according to a given
logic. The best part of the IF formula is that you can embed formulas and function in
it.

=IF(logical_test, [value_if_true], [value_if_false])

6. TRIM

It ensures that all empty spaces are eliminated. Unlike other functions that can
operate on a range of cells, TRIM only operates on a single cell.

Example:
TRIM(A4) – Removes empty spaces in the value in cell A4.

7. MAX & MIN

The MAX and MIN functions help in finding the maximum number and the
minimum number in a pool of values.

=MIN(number1, [number2], …)

8. INDEX & MATCH

The INDEX MATCH MATCH formula is the combination of two functions in


Excel: INDEX and MATCH.

=INDEX() returns the value of a cell in a table based on the column and row
number.

=MATCH() returns the position of a cell in a row or column

9. CONCATENATE

It is used to combine data into one cell. Say for example you had a first and last
name, in cells A1 and A2 respectively. You would type =CONCATENATE(A1," ",B2),
which would combine the names into one cell, with the " " adding a space in
bet=CONCATENATE(A1," ",B2), which would combine the names into one cell, with
the " " adding a space in between.

10.PROPER

PROPER is useful when your database has a lot of oddly formatted text that looks
jumbled with capitalizations in the wrong place. If cell A1 said "intErestIng
EnginEEring is greaT", you could type =PROPER(A1) and it would output "Interesting
Engineering is Great".

11.IF STATEMENTS

IF statements are super useful in a lot of situations, and this function allows you to
output text if a case is valid, or false. For example, you could write =IF(A1>A2,
"GOOD", "BAD"), where A1>A2 is the case, "GOOD" is the output if true and "BAD is
the output if false

You might also like