Counting Cells

  • Thread starter Thread starter Andrew Moseley
  • Start date Start date
A

Andrew Moseley

Here's what I have...

A1:A## - the winners of certain games
B1:B## - the pick of a person on each of those games

What I want to do is write a formula so that when I enter
in the winning teams it automatically counts up the right
picks at the bottom of the sheet.

I assume there is someway to use the "COUNTIF" formula,
but I can't seem to figure it out...can someone help me?

Thanks,

Andrew Moseley
 
Hi Andrew,

How do you record the pick of a person? With an "X", a
teams name, or something else? I have a very basic
workbook that does this. I can email a copy to you if
you'd like. Post back if interested.

Biff
 
Well, here is how it goes...

Column A is the matchup (ie: UGA vs. Vandy)
Column B is the winner (ie: UGA)
Column C is a person's pick (ie: UGA)

Right now I have it conditionally formatted where if the
pick is equal to the winner then it is green, otherwise
red.

At the bottom I have the number of picks that were right
and the number of picks that were wrong along with a
percentage of right picks.

What I would like to do is have Excel figure up the
number of right picks so I don't have to go count them
all up. Is there a way to do this? If so would you mind
emailing me at the following address?

(e-mail address removed)
Andrew Moseley
 
Andrew,

You can use:

{=SUM((A1:A100=B1:B100)*1)}

It has to be array entered (use ctrl+shift+enter instead
of enter only) XL will place the '{}' automatically.

Regards,
Felipe
 
Back
Top