Excel Formula to Sumif between Two Dates

SUMIF excel function is used to sum values between a different date range. The cells values are added based on specific criteria or a set of conditions. SUMIF function is…

Comments Off on Excel Formula to Sumif between Two Dates

Excel Formula to Compare Two Columns and Return a Value

You can compare data in a column and match the content to a different column. Different Excel formula can be used to compare two columns, find the matches in the…

Comments Off on Excel Formula to Compare Two Columns and Return a Value

How to do Formula Nesting in Excel

Sometimes when working with Excel, you may need to do a calculation that involves several formulas. One way of handling this is to break each formula out in its own…

Comments Off on How to do Formula Nesting in Excel

Excel Formulas for Accounting and Finance

Excel spreadsheet is a common tool used by every accountant or financial analyst to analyze, report and share financial information. Some basic excel functions let you perform complex calculations and…

Comments Off on Excel Formulas for Accounting and Finance

How to use Logical AND, OR and IF Functions in Excel

The IF function is used to perform logical test and return one value if the condition is TRUE and another for FALSE results. Combining AND, OR and IF function varies…

Comments Off on How to use Logical AND, OR and IF Functions in Excel

How to use COUNTIF function with multiple criteria

COUNTIF function is one of the most common excel function used for counting numbers within a specific range. The number of cells in the range should match the supplied criteria.…

Comments Off on How to use COUNTIF function with multiple criteria