Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Local elections
I want to create a spreadsheet to add up local precincts, give me a total and
the percentage of people that cast or did not cast votes based on my imput |
#2
|
|||
|
|||
Local elections
Okay...
In row 1 (your headings) Column A: Precint Column B: Number of votes cast Column C: Number of votes not cast Column D: Total voters Column E: Percentage of voters Column F: Percentage of non-voters In row 2 Column A: the name of your precint Column B: number Column C: number Column D: =sum(B2:C2) Column E: =B2/D2 column F: = C2/D2 Copy columns D to F down as many rows as you have data. Enter your data in Columns to C from row 2 down. You may want to format Columns E&F with a percentage format. Hope this helps, -- Ken Puls www.officearticles.com "D" wrote in message ... I want to create a spreadsheet to add up local precincts, give me a total and the percentage of people that cast or did not cast votes based on my imput |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shared workbook, local temp-file and network traffic | Excel Discussion (Misc queries) | |||
Stoping users from saving tables to their local machines... | Excel Discussion (Misc queries) | |||
Denying local saves of spreadsheets... | Excel Discussion (Misc queries) | |||
Same Name refers to local ranges | Excel Worksheet Functions | |||
Excel files on local drives running from internet | Excel Worksheet Functions |