(Msg. 1) Posted: Fri Oct 30, 2009 7:41 am
Post subject: Counting the As and Bs Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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.
(Msg. 2) Posted: Fri Oct 30, 2009 7:52 am
Post subject: RE: Counting the As and Bs [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 3) Posted: Fri Oct 30, 2009 9:49 am
Post subject: Re: Counting the As and Bs [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
More detail as to layout
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1 DeleteThis @austin.rr.com
"Renegade" <Renegade DeleteThis @discussions.microsoft.com> wrote in message
news:BE4F4DE6-1D89-4881-9DFF-EBBF775D766E@microsoft.com...
>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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office