TedJordan.Org - Logo

TRUE and FALSE in Excel (with examples)

TRUE and False in Excel

Learn how to use TRUE and FALSE functions in Excel and how to count how many times they appear in your spreadsheet. Become a Spreadsheet Master with Ted Jordan!

How to use COUNTIF: greater than

COUNTIF: greater than, less than, not blank,… this Excel function is so handy! Learn how to use it in your spreadsheets with Ted Jordan.

How to get rid of DIV/0 error in Excel

Learn how to remove DIV/0 in Excel: get rid of DIV/0 or replace the error message with text. You could also change cells colour when the divide by zero error message is created by the system.

SUMIFS between two dates (Excel)

SumIF Function for Dates in Excek

SUMIFS between two dates, with multiple criteria or different types of criteria: learn how to use Excel conditional sum like a pro! If you don’t know what’s the difference between SUMIF and SUMIFS, this article is for you!