BYCOL
The BYCOL function in Google Sheets operates on an array or range and returns a new row array, created by grouping each column to a single value.
 How to use
BYCOL
formula?  Examples of using
BYCOL
formula BYCOL
formula not working? Similar formulas to
BYCOL
Usage
Use the BYCOL
formula with the syntax shown below, it has 2 required parameters:
 array_or_range (required):
An array or range to be grouped by columns.  LAMBDA (required):
A LAMBDA that's applied to each column in the given array or range to obtain its grouped value.
Examples
Here are a few example use cases that explain how to use theBYCOL
formula in Google Sheets.
Calculate the average of each column
The BYCOL function can be used to calculate the average of each column in an array or range. For example, if you have an array of sales data, you could use the BYCOL function to calculate the average sales for each month.
Find the maximum and minimum value in each column
The BYCOL function can also be used to find the maximum and minimum value in each column in an array or range. For example, if you have an array of exam scores, you could use the BYCOL function to find the highest and lowest score for each subject.
Count the number of unique values in each column
The BYCOL function can also be used to count the number of unique values in each column in an array or range. For example, if you have an array of customer names, you could use the BYCOL function to count the number of unique customers.
Common Mistakes
BYCOL
not working? Here are some common mistakes people make when using the BYCOL
Google Sheets Formula:
Forgetting to specify the LAMBDA function
The BYCOL function requires you to specify a LAMBDA function. If you forget to do this, the function will not work.
Using the wrong type of data in the LAMBDA function
The LAMBDA function must return a single value. If you try to use a function that returns multiple values, the BYCOL function will not work.
Not using the correct syntax for the LAMBDA function
The LAMBDA function must be in the correct syntax. If you use the wrong syntax, the BYCOL function will not work.
Related Formulas
The following functions are similar to BYCOL
or are often used with it in a formula:

ARRAYFORMULA
The
ARRAYFORMULA
formula in Google Sheets allows for the application of a formula to an entire column or range of data, without needing to manually copy the formula to each cell. It is most commonly used to simplify and automate complex calculations across large data sets. 
SUM
The
SUM
function in Google Sheets adds up a range of numbers. This function is most commonly used to sum the values in a range of cells. 
AVERAGE
The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

MAX
The
MAX
function returns the maximum value from a range of cells or a set of supplied values. It is commonly used to find the largest value in a dataset. 
MIN
The
MIN
formula is a statistical function that returns the smallest value in a set of numbers. It is commonly used to find the minimum value from a range of cells or a list of values.
Learn More
You can learn more about the BYCOL
Google Sheets function on Google Support.