How to Assign / Define Names To Formulas in Excel – Use Formulas Easily

Formulas are very much useful in Excel Sheets to calculate complex equations easily. Microsoft Excel has no way to paste commonly-used formulas. You can make your formulas more accessible by assigning names to your formulas. This tip will let you use any of your excel formulas by just using the defined name in the space […]

How to Count Blank And Non-Blank Cells in MS-Excel

Figuring out the number of non-blank cells in a range is not entirely straightforward. The COUNTBLANK function returns the number of blank cells in a range, but what if you want to count the number of non-blank cells in the same range? One way is to use the COUNTA function:=COUNTA(B1:B13). The problem with this formula […]