Excel IF: All You Need To Know (2019 Guide)

Excel IF: The Ultimate Guide Intoduction Let me start by saying that the Excel IF Statement is my favourite Excel Function of all time! It is the purest form of Logic and in order to take our work to the next level we need to be able build logic. What is this Function so important? In brief summary, the Excel’s IF function performs a user instructed logical test, if that [...]

COUNTIF: Master This Amazing Formula (2019 Guide)

Excel Countif Function Introduction to Conditional Counting We all know that Excel has a variety of built-in functions. But did you know that the most used functions in Excel are the functions that count and sum? So today, I am happy to discuss and explain (the best I could!) these functions under the statistical category specifically those used for conditional counting – COUNTIF, COUNTIFS, COUNTBLANK. With these functions solely [...]