i have made a spreadsheet for work.. now they want me to find a way so that
they can find out how many people came from a certain ward.. there are 300
people on the list and they add on more everyday! what do i do?

More detail would help, but I'll make some assumptions... each person has
their own rown in your list, the ward is in a certain column, say column C,
and there's nothing else on the worksheet, except perhaps column headers. If
you want to just count the number of times a certain way, "Ward 1", appears,
=countif(c:c,"Ward 1") will do it. You could put that off to the right of
the main table. In fact, if you put the list of wards in column K, starting
in K2, then in L2 you could enter the formula =countif(c:c,k2). Then just
copy that formula down (grap the fill handle on the lower right of the cell
and drag down as many cells as needed). You'll wind up with a nice table of
ward name and count.
HTH. --Bruce


"Mrs.S.Paul" wrote:

> i have made a spreadsheet for work.. now they want me to find a way so that
> they can find out how many people came from a certain ward.. there are 300
> people on the list and they add on more everyday! what do i do?