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 ...