Windows Character Set (1252)

Windows Character Set is a one byte character encoding system derived from Latin alphabet. The character set shares same characters up to first 128 character with ASCII character encoding. Excel’s the CHAR function uses this characters set for Windows versions....

MAC OS Character Set

Mac OS Character Set is based on one byte character encoding system, Mac-Roman. The character set shares same characters up to first 128 character with ASCII character encoding. Excel’s the CHAR function uses this characters set for Mac versions. Code...
How to use double quotes in Excel formulas

How to use double quotes in Excel formulas

Excel uses double quote character to identify text, you need to a different approach. This article shows you How to use double quotes in Excel formulas in two ways: with and without a function. Syntax =”””” =CHAR(34) How There are 2 ways to use...
Count values with Excel intersect operator

Count values with Excel intersect operator

Excel intersect operation is handled by the space character (” “). You can intersect multiple rages by space in range supporting formulas. This article shows how to COUNT intersecting ranges with COUNT function and Excel intersect operator. Syntax...
How to calculate SUM with intersecting tables

How to calculate SUM with intersecting tables

This article shows how to calculate sum with intersecting tables using SUM function and intersect operator, the space character (” “). Syntax =SUM(first range second range) Steps Type =SUM( function Select or type the first range reference that includes...
How to count by month

How to count by month

To count by month has nothing different than How to COUNT values between two dates. However, this article shows you a more dynamic and specialized way with EOMONTH function that you don’t need to guess how many days in a month to count month. If you only want to...
How to calculate monthly averages

How to calculate monthly averages

This article shows you how to calculate monthly averages from a data table containing dates and values using AVERAGEIFS and EOMONTH functions. If you only want to calculate the number of days in a month, please refer to the article: How to find number of days in month...