The spread sheet has 2000 plus names and addresses. Not all people will be
attending the event.
Col H = the state/prov, Col Q contains the number of people in that row
attending Is it possible to have in another sheet named totals for example a
list of all the states and provinces in one column, and in the next column
display the total number of people from that state/prov attending the function?

--

Regards
Michael Koerner