Use the =SUM() function.

Let's say we assign a separate column to each county and a separate row to
each candidate.

=SUM(13:13) will give the total votes for the candidate in row 13 and
=SUM(D:D) will give the total votes cast in county D.
--
Gary''s Student - gsnu200719