Excel :: IF Function With Multiple Conditions

Sum On Multiple Conditions In Multiple Columns My data looks somewhat like this : X Y Z DOU Quarter Sum 0 Q1 = sum of 1's in Q1 1 Q1 = sum of 1's in Q2 1 Q2 = sum of 1's in Q3

excel.bigresource.com