When working in Excel, you can quite often have a situation, that values in your spreadsheet look like numbers, but they don’t sum up, multiply or cause errors in formulas. The main reason for this is formatting values as text […]
Cleaning, editing and transforming text is very important part of work in Excel. In this article, you can find out 10 most useful and most popular text function, which will improve your work with text data in Excel. LEFT RIGHT […]
COUNTIF is very useful function in Excel. It allows to calculate, how many cells in given cell range include specified criteria. Syntax of COUNTIF function How to define COUNIT criteria? Example 1 – basic usage of COUNTIF function Example 2 […]
Quite often we need to calculate sum of values which meet specific conditions, for example are less or greater than 0. For such cases, Excel has special function – SUMIF, which is used to sum values from a given range, […]
Quite often, data in an Excel spreadsheet is not ordered in the required way. Sometimes you need to combine texts kept in different cells to one cell. In today’s article, I will show you some methods for combining texts in […]
Weighted average is a calculation, which includes various degree of importance of values. From this article, you will learn how to calculate a weighted average in Excel by using the SUMPRODUCT and SUM formulas. SUMPRODUCT formula In one of my […]
When working with numeric data, sooner or later you will need to calculate average values. In this article, I will show you basic methods of calculating average in Excel. Command Average on the Ribbon The first, most basic method of […]
Excel functions simplify calculations and working on large amounts of data. Thanks to several key functions, you can perform various actions in Excel that will increase performance and significantly reduce the possibility of making calculation errors. There are lot of […]