Site Loader
Get a Quote

Arithmetical functions

Arithmetical functions in excel:- Hi Readers, In this blog you will get to know arithmetical functions in excel.We have discussed here all count functions like count(), counta(), countblank(). These all are important function of arithmetical functions in excel

Count(Arithmetical functions)

What Does It Do?

This function counts the number of numeric entries in a list, it will ignore blanks, text, and errors.

Syntax

=COUNT (Range1, Range2, and Range3… through to Range30)

Formatting

No special formatting is needed.

Example

The following table was used by a builder’s merchant to calculate the number of sales

for various products in each month.

A B C D
ITEM JAN FEB MAR
Bricks $1000
Wood $5000
Glass $2000 $1000
Metal $1000
Count 3 2 0

=Count(B3:B5)

COUNTA(Arithmetical functions)

What Does It Do?

This function counts the number of numeric or text entries in a list.

It will ignore blanks.

Syntax

=COUNTA(Range1,Range2,Range3… through to Range30)

Formatting

No special formatting is needed.

Example

See the below table…

In the above table, Formula counts only number and words, NO blanks.

COUNTBLANK(Arithmetical functions)

 

What Does It Do?

This function counts the number of blank cells in a range.

Syntax

=COUNTBLANK(RangeToTest)

Formatting

No special formatting is needed.

Example

The following table was used by a company which was balloting its workers on whether
The company should have a no smoking policy.
Each of the departments in the various factories was questioned.
The response to the question could be Y or N.
As the results of the vote were collated they were entered into the table.
The =COUNTBLANK() function has been used to calculate the number of departments which have not yet registered a vote.

  

1   B C D E F
2 FACTORY1 Y N Y    
3 FACTORY2   Y   Y N
4 FACTORY3 N       N
5 FACTORY4 Y N Y    
6 FACTORY5   N   N Y
7 FACTORY6   N Y    
8 FACTORY7 Y   N   Y
9 FACTORY8 N N     Y
10 FACTORY9 N Y   N Y
11 FACTORY10 Y   N    

The Result will be- vote not yet registered =Countblank(B2:F11) and answer will be (25)

COUNTIF(Arithmetical functions)

What Does It Do?

This function counts the number of items which match criteria set by the user.

Syntax

=COUNTIF (RangeOfThingsToBeCounted, CriteriaToBeMatched)

The criteria can be typed in any of the following ways.

  • To match a specific number type the number, such as =COUNTIF(A1:A5, 100)
  • To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,“Hello”)
  • To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5, “>100”)

Formatting

No special formatting is needed.

Example

The following table was used by a company which was balloting its workers on whether

The company should have a no smoking policy,

Each of the departments in the various factories was questioned.

The response to the question could be Y or N.

As the results of the vote were collated they were entered into the table.

The =COUNTIF    () function has been used to calculate the number of departments which

have registered a vote , Either which YES or NO.

1   B C D E F
2 FACTORY1 Y N Y    
3 FACTORY2   Y   Y N
4 FACTORY3 N       N
5 FACTORY4 Y N Y    
6 FACTORY5   N   N Y
7 FACTORY6   N Y    
8 FACTORY7 Y   N   Y
9 FACTORY8 N N     Y
10 FACTORY9 N Y   N Y
11 FACTORY10 Y   N    

Votes for Yes: =COUNTIF(B2:F11,”Y”)

Votes for No:=COUNTIF(B2:F11,”N”)

COUNTIFS (Arithmetical functions)

What Does It Do?

This function counts the number of cells in a range that matches particular criteria, which has been set by the user.

Syntax

=COUNTIFS( criteria_range1, criteria1, [criteria_range2, criteria2, … criteria_range_n, criteria_n] )

Formatting

No special formatting is needed.

arithmetical functions

Post Author: TechieFlair

Leave a Reply

Your email address will not be published.