Hi Violet

Two options. Easiest option create a pivot table of your data, (use the
wizard if you are not familiar with pivot tables). The other option is to use
the sumif function, you will need to type each country into a cell for this.
--
Tony Green


"violet" wrote:

i have a worksheet that categorize people into category n country. i need to
do a sum of all these ppl. is there a way to code a program to count the
number of name and insert it in certain cells.