hotpepper, there's nothing wrong with what you said, but I'll mention that when I give sumif examples I usually add the $ anchors, having myself been beaten up by that so many countless times. ( Generally, I try to condition myself to add them immediately after constructing a SUMIF. Too bad you can't type $ while entering the formula (that is, when you navigate the ranges). )