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...
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...
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 Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.