Hi; I have what is hopefully a dumb question. Often in forms I'd like to duplicate the Excel function "SumIF"; I'm not sure how to do it. For example, I created a form footer calculated field which I would LIKE to subtotal only certain records displayed on the form. Any ideas? Thanks in advance for you help, this is aggravating!!