Hello all... If you have a named range of 3 rows and I'm trying to come up with a formula to SUM the 2nd row and SUMIF the 2nd row based on 3rd row YES/NO... Respectfully, Paul F