Karen

countif will work for summing or counting as long as all you numbers
are 1's. If that is not the case in you real data then you can use
sumif(), or sumproduct() or a pivot table.

Good luck.

Ken

On Oct 11, 12:03 pm, "Dan R." wrote:
Use the countif() function.

--
Dan Oakes