How to SUM if with comparison operator in Excel

In this article, we will learn How to SUM if with multiple comparison operators in Excel. SUM values with less than, greater than or equal to g...

How to Sum values in vertical and horizontal ranges in

In this article, we will learn How to Sum values in vertical and horizontal ranges in Excel. SUM entire column In Excel, working with array ...

Coloring One Record in Each Group in a Range

In this article, we will learn How to Coloring One Record in Each Group in a Range in Excel. Scenario: Sometimes given a list of values we n...

How to calculate the date at the end of a

In this article, we will learn How to calculate the date at the end of a month in Excel. Scenario: At times, we need to know the expiry date...

How to format odd number and even number rows in

How to format odd number and even number rows in Excel In this article, we will learn How to format odd numbers and even number rows in Exc...

How to hide cells before printing in Excel

In this article, we will learn How to hide cells before printing in Excel. How to hide cells in Excel Problem occurs when a user needs to ge...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.