Skip to main content

COLUMNS Function in EXCEL


COLUMNS Function:




Summary
COLUMN function returns the count of columns selected.

First will let you know about the purpose and syntax of the same.

Purpose
To get the number of columns in an array or selected table range.


Arguments & Syntax

=COLUMNS(A5:C6)
=COLUMNS(array)

As given above syntax contain 1 argument, the meaning of the same is given below.

Arguments
Meaning
array
In this function selected columns are array, does not matter the same is only columns, columns along with row’s or any data filled table.

Translation

COLUMNS function we can use to know the column count for the selected range or reference.

Selected range can be only columns, can be columns and row’s or any other data filled table bur function will return only columns count.

Example:1

Range selected: =(COLUMNS(A5)

Sr. No.
Argument
Selected Range
Result
Remark for result
1
Array
A5
1
One single cell is selected

Example:2
Range selected: =(COLUMNS(A5:C5)

Sr. No.
Argument
Selected Range
Result
Remark for result
1
Array
A5:C5
3
Only three columns are selected
(Column A, Column B and Column C)

Example:3
Range selected: =(COLUMNS(A5:C6)

Sr. No.
Argument
Selected Range
Result
Remark for result
1
Array
A5:C6
3
Only three columns are selected
(Column A, Column B, Column C
And
Row’s ignored as the same is function nature.)

Example:4
Range selected: =(COLUMNS(A6:G6)

Sr. No.
Argument
Selected Range
Result
Remark for result
1
Array
A6:G6
7
The result is 7 as seven columns are selected. For our understanding we can count the columns from Column A to Column G.

Click here to download the excel file or open with Google sheet.

Function Return Value
Getting the number of columns in an array or selected table range.

Functions Used
=(COLUMNS(A6:G6)

Evaluation Operator
Meaning
=
Equal To

Important Notes:
COLUMNS function returns only columns count, the range does not matter.

Are you having any Questions or Comments? Hit me!
Labels:

Comments

  1. Hitesh SharmaJune 16, 2020 at 6:39 AM

    Hi,
    If anyone having anything in excel, in which they are stuck, let me know once only...i will be back in as soon as possible with my best efforts...

    ReplyDelete
  2. ChhayaJune 16, 2020 at 6:44 AM

    Hi,
    Where this function will work in excel and why???

    ReplyDelete

Post a Comment

Popular posts from this blog

MATCH Function:

MATCH Function:       Summary The  MATCH  function searches an item in a range of cells and then returns the relative position of that item in the range. For example, if the range is H4:H7 contains the values SONU, PAWAN, HARUN, and RITTULBHAI, then the formula =MATCH("HARUN",$H$4:$H$7,0) returns the number 3 because HARUN is the third item in the range. Trick Tip : You can use the MATCH function to provide a value for the row_num argument of the INDEX function, using this function you don't need to write numbers manually. So, advise you to use this MATCH function with INDEX function, VLOOKUP , HLOOKUP, etc. First will let you know about the purpose and syntax of the same.   Purpose The MATCH function can use to searches an item in a range of cells and then returns the relative position of that item in the range. Arguments & Syntax     As given above syntax contain 3 different arguments, meaning of the ...
1 comment
Read more

Excel - IF Function || IF formula || English article and Hindi Video

Excel IF Function   Summary The IF function can perform a logical test and return one value subject to TRUE and FALSE value placed by you. IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and whatever you want. For example, to avail incentive, branch should do more than 5 crores sell in a month:  =IF(B2>5,"Eligible","Not Eligible") So, IF function provided two results. First for your TRUE comparison and Second for FALSE comparison as an example given above. Open this video to understand IF function with different data: Above Youtube video link:   https://www.youtube.com/watch?v=CQzsydfB_EE   Purpose IF is a conditional function, who helps us to find out a result on the basis of conditions entered by you.   Translation =IF(B2>5,"Eligibile","Not Eligible") If in the above formula value in “B2” is greater than 5, the return value is Eligible. Otherwi...
2 comments
Read more

Excel – VLOOKUP Function along with Hindi Video

VLOOKUP Function: Summary VLOOKUP is one of the most powerful tools in Excel. The VLOOKUP function enables you to look up data corresponding with the row of a lookup value and corresponding column index. It sounds like a very simple thing, and it is. For example, the VLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table. You can create a simple Excel table that uses VLOOKUP to lookup and present data from one or other tables.   Don’t worry if it’s sound little difficult, by the end of this article, you will be able to teach others about the VLOOKUP.   First will let you know about the purpose and syntax of the same.   Purpose The VLOOKUP function can use the relational data essentials of two separate tables and affix the data from one table to the other table.   Arguments & Syntax   As Syntax given above VLOOKUP  contain 4 different arguments, the ...
2 comments
Read more