Excel SUM

Excel SUMIF Function

This post will guide you how to use Excel SUMIF function with syntax and examples in Microsoft excel. Description The Excel SUMIF function sum the numbers in the range of cells that meet a single criteria that you specify. You can use the SUMIF function to sum cells that based on the dates, numbers or… read more »

How to Count Numbers with Leading Zeros

This post explains that how to count numbers with leading zeros as Text format in excel. How to count numeric format strings with a different number of leading zeros using excel formula. Count Strings with Leading Zeros Suppost you have a list of product ID in your worksheet, and the product ID contains the different… read more »

How to SUM a Column with Lookup value in a Range

We have described that how to lookup value and retrieve the entire column in the previous post. And this post will guide you how to get the sum of the entire column with lookup value in a range in excel. SUM Column with Lookup Value If you want to lookup value in a range and… read more »

SUM Function in Excel

This post will guide you how to use Excel SUM function with syntax and examples in Microsoft excel. Description The Excel SUM function will adds all numbers in a range of cells and returns the sum of these values. You can add individual values, cell references or ranges in excel. The SUM function is a build-in… read more »

Split Text and Numbers in Excel

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can run the following excel formula that use the MIN function, FIND function and the LEN… read more »

Sidebar