The Sum, SumIf, SumIfs Functions

Sum | SumIf | SumIfs

In this post we will learn Sum function.

Sum

The Sum function sums the Numeric values. See below snapshot

The Count, CountIf & CountIfs Function

Count | CountIf | CountIfs

In this post we will learn Count functions.

Count

The Count function counts the range of cells or occurrence of a value which contains Numeric values. See below snapshot:

Mathematical Functions

Count | Sum | Average | Max | Min | Large | Small

1. Count/CountA/CountBlank

The Count function counts the Numeric values in a range. In below example Count function (Cell B10) returns the value 5, which is count of numeric values in range B1:B8.

The CountA function counts the Numeric & Alphabetical values in a range. CountA function (Cell D10) returns the value 7, which is count of numeric and alphabetical values in range D1:D8.

The CountBlank function counts the Blank cells in a range. CountBlank function (Cell F10) returns the value 1, which is count of blank cells in range F1:F8.

Text Functions

Concatenate | Find/Search | Left/Right/Mid | Proper/Lower/Upper | Trim | Len | Replace/Substitute

Concatenate

The concatenate function is used to join two or more words or text strings together. 

Syntax: =CONCATENATE(text1, [text2], ...)  

 

Same way we can use "&" operator to concatenate two or more text strings.

 Copy the formula from here : 

• =CONCATENATE(A2," ",B2)
• =A2&" "&B2

Note: " " = Blank