I don't know anything at all about a pivot function but I did google it and I don't think that it would fit my need; I was thinking more of a combination of the IF and count functions, if that is at all possible. I have a basic knowledge of spreadsheets, all self taught and mostly figure things out by trial and error.