Google Sheets Function: BYCOL

The BYCOL function applies a LAMBDA function to each column of the entered table.

Prerequisite: understand the LAMBDA function.


=BYCOL(array_or_range, LAMBDA)

Example of use

The objective here will be to calculate the total of each column using a single formula:

google sheets best supplier bycol

Enter the BYCOL function followed by the table that contains the prices:


Then add the LAMBDA function and choose a variable name (for example "price"):


And to finish, add a SUM function to calculate the total:


The BYCOL function will then traverse the entered table (B2:D11) column by column and return the total of each column:

google sheets functions bycol lambda sum
If needed, you can copy the Google Sheets document (or view the document) with this example.