by Ilker | Jul 2, 2018 | Excel Tips & Tricks
Case sensitive count can not be handled easily using standard count formulas like COUNTIF or COUNTIFS. In this article, we’ll shot you how you can count case sensitive data by using a combination of SUMPRODUCT and EXACT functions. Syntax...
by Ilker | Jun 13, 2018 | Excel Tips & Tricks
The AVERAGEIFS function can calculate the average of values with multiple conditions. However, these conditions are linked with AND operator. But if you want to handle AVERAGE OR combination, AVERAGEIFS function will not work. This article shows how to calculate...
by Ilker | Jun 13, 2018 | Excel Tips & Tricks
The SUMIFS function can sum values based on multiple conditions. However, these conditions are all linked with AND operator. As a result, all conditions should be fulfilled to return a value. This article shows How you can sum values with multiple OR operators using...
by Ilker | Jun 13, 2018 | Excel Tips & Tricks
You can count values in Excel by multiple criteria using the COUNTIFS function. However COUNTIFS will only link those criterion by AND operation. If you want to COUNTIFS OR, you need an alternative approach. This article shows how to count values with OR operator...
by Ilker | Jun 12, 2018 | Excel Tips & Tricks
The LEN function is used to count characters in Excel. But it doesn’t support ranges or arrays to easily count total number of characters in a range. This article shows 2 ways to count characters in Excel in a range which uses SUMPRODUCT and SUM along with LEN....
by Ilker | Jun 12, 2018 | Excel Tips & Tricks
Excel has a built in function to calculate Least Common Multiple (LCM) of two or more integers. The function is also called LCM. Syntax =LCM(number1, [number2], …) Steps Start with =LCM( Type or select cells or range that includes integers B6:E6 Type ) to close the...
by Ilker | Jun 12, 2018 | Excel Tips & Tricks
To calculate Greatest Common Divisor (GCD) in Excel is very straightforward. Excel has a built in function to calculate the greatest common divisor of two or more integers. The function called GCD. Syntax =GCD(number1, [number2], …) Steps Start with =GCD( Type or...
by Ilker | Jun 12, 2018 | Excel Tips & Tricks
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....
by Ilker | Jun 12, 2018 | Excel Tips & Tricks
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...
