Excel Forum
Similar Content
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
Macro: Delete all chart sheets and tabs in Excel using this macro. This will only delete the char...
Sum a Range with Errors in Excel
Tutorial: How to sum a range of cells that contains errors. This requires an array formula, so it w...
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...



Excel Magic Trick 367: Any Number Not Zero = TRUE


See that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE. See this trick in an IF, SUMIF and SUM formula for Conditional summing. Adding with more than one criteria more than one condition.





Got a Question? Ask it Here in the Forum.