The COLUMN formula is one of the lookup functions available within Google Sheets. It gives us the column number where...
How to use the COLUMN formula in Google Sheets
read more
Spreadsheets articles
How to use the DATE formula in Google Sheets
In spreadsheets, working with dates can be a hassle. Sometimes date formats are not properly recognized, and to use...
How to use the EDATE formula in Google Sheets
In Google Sheets application, if we need to know the date a specified number of months before or after a given date,...
How to use the NETWORKDAYS formula in Google Sheets
In Google Sheets application, if we need to know the number of net working days between two specified dates,...
How to use the TRANSPOSE Google Sheets formula
In Google Sheets, if you ever need to flip the columns and rows of an array or a data range, TRANSPOSE Google Sheets...
How to use the ARRAY_CONSTRAIN formula in Google Sheets
In Google Sheets, the ARRAY_CONSTRAIN formula returns a subset of the input range, characterized by the specified...
How to use the DAVERAGE formula in Google Sheets
The DAVERAGE formula in Google Sheets is almost similar to that of the AVERAGEformula, but with a distinction. It...
How to use the AVERAGEIFS Google Sheets formula
The AVERAGEIFS Google Sheets formula is similar to that of the AVERAGEIF Google Sheets formula, but with a slight...
How to use the AVERAGEIF formula in Google Sheets
The AVERAGEIF formula in Google Sheets is similar to the AVERAGE formula, but there's a key difference. Like the name...
English 
Español 
Português do Brasil 
Français