I need to get a column totaled. The prob is that its non standardized. If the cell is NOT empty it is equal to one otherwise it is equal to zero. I want to create a process that will total that column across pages in a spreadsheet and make entries on another page based on results. ie

The pages have 3 columns ("UIC","NAME","VOLUNTEER") the pages represent regions, on all pages the first row is the title row. If the volunteer column on rows 2 and higher are NOT empty I want to add 1 to a grand total AND copy the UIC from that row to another page.

So if page 1 had 3 entries:
uic name Volunteer
abc joe X
qwe fred
wab mike x

And if page 2 had 5 entries:
uic name Volunteer
aer john y
bwn cindy y
jyb adam
ewn sandy y
jee anna

My total would be 5 and I would have a list like:
abc
wab
aer
bwn
ewn

If anyone has any ideas I would be most appreciative. Excel is not my bag. (until the boss came in this morning) [se la vie]