SOMEKA BLOG
Combining business know-how into Excel and Google Sheets tips to provide hundreds of interesting articles.
RECENT POSTS
How to use Excel YEAR function
Excel YEAR function returns a four-digit year (a number from 1900 to 9999) given a date value. Other Languages and Syntax Details are listed.
How to use Excel MONTH function
Excel MONTH function returns the month (a number from 1 to 12) given a date value. Other Languages and Syntax Details are as listed.
How to use Excel DAY function
Excel DAY function returns the day of the month (a number from 1 to 31) given a date value. Other Languages and Syntax Details are as listed.
How to use Excel ROUNDDOWN function
Excel ROUNDDOWN function returns a number rounded down to a specified number of digits. Other Languages and Syntax Details are as listed.
How to use Excel ROUNDUP function
Excel ROUNDUP function returns a number rounded up to a specified number of digits. Other Languages and Syntax Details are as listed.
How to use Excel SUMIFS function
Excel SUMIFS function adds the cells in a range that meet multiple criteria. Other Languages and Syntax Details are as listed.
How to use Excel COUNTIFS function
Excel COUNTIFS function counts the number of cells within a range that meet multiple criteria. Other Languages and Syntax Details are as listed.
How to use Excel INDIRECT function
Excel INDIRECT function returns a reference indicated by a text value. Other Languages and Syntax Details are as listed.
How to use Excel OFFSET function
Excel OFFSET function returns a reference offset from a given reference. Other Languages and Syntax Details are as listed.