Thanks - Sumif is what I needed. I realized that my example was not as
clear and was about to repost, I am actually trying to sum the values in the
second column, which will not always be 1.

Thanks for your help.

" wrote:

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