## At A Glance

### Excel Magic Trick 793: Add Between Two Dates/Times/Numbers SUMIF & SUMIFS 10 Examples

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm1. Add between (inclusive) two dates using Two SUMIF functions (Date criteria and Comparative Operator in cell) (minute mark: 00:43 )2. Learn the logic of how the Two SUMIF functions calculate (Date criteria and Comparative Operator in cell) (minute mark: 00:43)3. Add between (inclusive) two dates using SUMIFS function (Date criteria and Comparative Operator in cell) (minute mark: 04:25)4. Learn the logic of how the SUMIFS function calculate (Date criteria and Comparative Operator in cell) (minute mark: 04:25)5. Add between (inclusive) two dates using SUMIF or SUMIFS with Ampersand Join Symbol used to connect date criteria in cell and Comparative Operator in formula. (minute mark: 07:07)6. Learn reason to join date criteria and comparative operator: When date formula input will be used as formula inputs in multiple formulas. (minute mark: 07:07)7. See TEXT function to create Labels from Date inputs. (minute mark: 07:07)8. Add between two dates when the upper and lower date are not necessarily included (non-Inclusive). (minute mark: 12:56)9. Add, count and average between (inclusive) two times. (minute mark: 17:15)10. Add Between Two Numbers. (minute mark: 07:07 or 19:13)11. AND Criteria Condition, Between Criteria Condition, Two Logical Tests Must be met to Add, Add with Conditions Criteria. (minute mark: Whole video)
Length: 20:20

## Contact

Questions about Excel Magic Trick 793: Add Between Two Dates/Times/Numbers SUMIF & SUMIFS 10 Examples