Reply to thread

Message: [QUOTE="Racer X, post: 3831052"] I am trying to generate a SUMIF statement that looks at the value in COlumn A to determine if it falls within a range. DATA Probability Fees 100% 100 76% 100 75% 100 55% 100 50% 100 To get the results in the table below my thinking was: For Cell B1 -> =SUMIF(A1:a5, >.99, b1:b5) For Cell B2 -> =SUMIF(A1:a5, >.75 AND <1, b1:b5) For Cell B3 -> =SUMIF(A1:a5, >.50 AND <.76, b1:b5) DESIRED RESULT 100% 100 Confirmed 76% - 99% 100 Probable 51% - 75% 200 Possible The formula for cell B1 works, but I cannot get the range to work in the cells for B2 and B3. Am I making any sense? Much thanks! Race on, John [/QUOTE]