I hope you do enjoy this free blog. I only ask one thing from you in return, click in one of the ads

Friday 16 January 2015

COLUMNS function

Category: Lookup and reference functions

What does this function do?


Returns the number of columns in an array or reference.



Syntax:
COLUMNS(array)
  • Array: An array or array formula, or a reference to a range of cells for which you want the number of columns.


Examples:
=COLUMNS(B2:C5)=2
=COLUMNS(C7:F10)=4
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)