## Count the Number of Characters in a Cell – Excel LEN Function

In this tutorial, we will learn about Excel LEN Function, basically, we use this function to count the length of the cell string or value. This function counts every single character including a single space too. Why we use this?   Excel LEN function is very useful to count or find the length of the …

## How to Use Excel SUBTOTAL Function – A Detailed Guide

In this tutorial, we will learn about Excel SUBTOTAL Function. This is one of the powerful, easiest and most useful function in Excel. This function increases the usability of some basic functions. What is SUBTOTAL Function in Excel?   The SUBTOTAL is a most useful and versatile function in Excel. This function works dynamically in a …

## How to use Excel ISNA Function – An introduction

Excel ISNA Function reads the cell value if it is an error code #N/A then it will return as TRUE otherwise FALSE.

## How to use Excel ISERR Function – An Introduction

Excel ISERR Function checks the value in a cell, apart from #N/A, if a cell has any of the following errors like – #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? and #NULL!, it will return TRUE otherwise FALSE. This function is a member of IS group of functions in Microsoft Excel. Why we use Excel ISERR Function? …

## How to use Excel ISNONTEXT Function – An introduction

Excel ISNONTEXT Function is a logical operator and returns TRUE or FALSE as a result. This function returns TRUE for values like – date, number, time, etc. and returns FALSE for all text values. Excel ISNONTEXT is a member of IS group of functions in Microsoft Excel. Why we use this?   This function test a cell …

## How to use Excel ISREF Function – An introduction

Excel ISREF Function is a member of IS function in Microsoft Excel. This function checks, if cell value refers to another cell. If refer, it returns as TRUE and if not then FALSE. What is the syntax for ISREF?   =ISREF (value) Syntax Explained   Value (required) – cell value to be checked for a …

## How to Use Excel SUMIFS Function for Multiple Conditions

Excel SUMIFS Function sums the values of a column in a dataset, where result meets or fulfils with multiples of condition or criteria. Microsoft has introduced this Function in 2007 and available after all the versions. What is the difference between Excel SUMIF and SUMIFS function?   Excel SUMIF Function make a sum of values …

## How to use Excel SUMIF Function in Multiple Condition (with examples)

Excel SUMIF Function – An introduction   Excel SUMIF Function sums the values in a range with one criteria or condition. In this blog post, we are going to learn more about Excel SUMIF Function. SUMIF is a combined function of Excel SUM and IF function. SUM function sums the values in a range and IF …

## Excel SUM Function – Five Methods To Use

Excel SUM Function – Definition   Excel SUM Function makes the sum of numeric values in a cell or range of the cells. Which including numbers, cell references, ranges, arrays and skip text values or blank cells.   The Syntax of Excel SUM Function   =SUM (number1, [number2], ….] Argument Explanation   number1 = this …

## Excel COUNTIFS Function – How to Use (with example)

This tutorial describes the formula syntax and usage of the Excel COUNTIFS Function and its usages. Definition – Excel COUNTIFS Function   Excel COUNTIFS function is a member of COUNT family in Microsoft Excel and advanced version of Excel COUNTIF Function. Excel COUNTIFS function count the number of cells in a data-set or range with a …