Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting the As and Bs
I need a formula that will add up the number of votes received by each
candidate. Committee members will designate their vote by rating the candidate with either an A or B, and I want to be able to apply a formula that will provide the total of As or Bs each candidate has received. Any assistance that can be provided will be greatly appreciated. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting the As and Bs
More detail as to layout
-- Don Guillett Microsoft MVP Excel SalesAid Software "Renegade" wrote in message ... I need a formula that will add up the number of votes received by each candidate. Committee members will designate their vote by rating the candidate with either an A or B, and I want to be able to apply a formula that will provide the total of As or Bs each candidate has received. Any assistance that can be provided will be greatly appreciated. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting the As and Bs
Hi,
=SUMPRODUCT((A1:A20="Candidate")*(B1:B20="A")) In practice it's best to use a cell reference for the name and vote =SUMPRODUCT((A1:A20=C1)*(B1:B20=B1)) Mike "Renegade" wrote: I need a formula that will add up the number of votes received by each candidate. Committee members will designate their vote by rating the candidate with either an A or B, and I want to be able to apply a formula that will provide the total of As or Bs each candidate has received. Any assistance that can be provided will be greatly appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTING | Excel Worksheet Functions | |||
counting function but not double counting duplicates | Excel Worksheet Functions | |||
Counting | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |