Excel Formula: Summing with Multiple Criteria Part 2
Thursday, October 9th, 2008 Posted in Formulas and Functions | 2 Comments »In Part 1 we looked at the following array formula for summing cells in the range A1:A1000 which are less than 50 or greater than 100 =SUM(IF((A1:A1000>100)+(A1:A1000<50),A1:A1000,0)) This array formula is quite specific so we need to look for a more general ...
Excel Formula: Summing with Multiple Criteria Part 1
Monday, October 6th, 2008 Posted in Formulas and Functions | 1 Comment »Excel provides a useful way of summing cells that satisfy a given criterion. The SUMIF worksheet function is designed specifically for this purpose. By way of example, let’s suppose you want to sum the cells in the range A1:A1000 which have ...
Excel Formula: Calculate Last Sunday and First Sunday in Month
Thursday, October 2nd, 2008 Posted in Formulas and Functions | 1 Comment »It’s daylight saving time again. Clocks go forward on the last Sunday in September and get put back on the first Sunday in March. Perhaps you, like me, need an Excel formula that calculates the first and last Sunday in a ...
