Google Sheets Function: BYCOL

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

Prerequisite: understand the LAMBDA function.

Usage:

=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:

=BYCOL(B2:D11

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

=BYCOL(B2:D11;LAMBDA(price

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

=BYCOL(B2:D11;LAMBDA(price;SUM(price)))

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.