COUNTIF, I don't want to type all this text...

[Exxcel Noob]

http://img38.imageshack.us/img38/7975/countteam.png

Hi everyone, I tried to count all the football team in sheet number 1, but I have to type in all the team name.

I have like 120 teams name; it is possible to count all the team name without typing all the text?

thank you

[benishiryo]

hi Exxcel Noob, instead of "Air Force", simply refer to the cell A1
=COUNTIF(Sheet1!C:C,A1)

[Exxcel Noob]

hi Exxcel Noob, instead of "Air Force", simply refer to the cell A1
=COUNTIF(Sheet1!C:C,A1)

it doesn't work, when I click A1 it gave me an error..
you have to type it out instead..
I believe click on a cell A1 only work on number. not letter

[Exxcel Noob]

you can try on your own spread sheet.

A1: Airforce (sheet 1)

B1: =countif(sheet1!A:A,A1) (sheet 2)

this will not work...

[Exxcel Noob]

omg never mind i figure out, thank you BENISHIRYO lol

[benishiryo]

ermmm i am assuming u your range u provided is correct? what this formula i gave u does is counting how many times the cell A1 in sheet2 appeared in the Column C of Sheet1.

But now u said Airforce is in A1 of Sheet1?

if Airforce is in Column A of Sheet1, it's:
=COUNTIF(Sheet1!A:A,A1)

[Exxcel Noob]

ermmm i am assuming u your range u provided is correct? what this formula i gave u does is counting how many times the cell A1 in sheet2 appeared in the Column C of Sheet1.

But now u said Airforce is in A1 of Sheet1?

if Airforce is in Column A of Sheet1, it's:
=COUNTIF(Sheet1!A:A,A1)

yes sorry, i confused myself lol.
but i get it, thank you so much!

[benishiryo]

=)
no problem~