Summing only the positive or negative values in the same range of values only sounds difficult. Fortunately, the SUMIF() function can handle both.

How to Do the Sum of an Indefinite Series in Excel. The Microsoft Excel program includes a variety of mathematical formulas that you can apply to any cell in a spreadsheet.

Using Excel as a scheduling tool is a great skill to have under your belt. Learn how to use SUM, DATE, WEEKDAY, IF, Nested IF, and IF/OR functions.