Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm not too good with Insert Function in Excel...

I basically built a table on a worksheet called Alunos, and want to do a countif from this worksheet to another.

I figured out how to copy content from a cell to another worksheet cell by typing: =Alunos!K9 (this copies the content from K9 of worksheet Alunos to a cell in my new Worksheet)

But now I want to do something a but more complex, I want to look up all the values in a column and count them, so I tried:

=Alunos!COUNTIF(AnoInscr:F200,"2008")

This is returning me an error on Alunos and I can't seem to figure it out...

On another less important question, is there a way for the function to search all the values in a column without me having to give a max value? In my example above I used F200 because I know my values won't reach cell 200, but this seems rather bad weak programming (if we can call it that).

share|improve this question

migrated from stackoverflow.com Jun 11 '12 at 12:31

This question came from our site for professional and enthusiast programmers.

add comment

2 Answers

up vote 1 down vote accepted
=COUNTIF(Alunos!F:F,"2008")

F:F means the whole column.

your alunos was in the wrong place it belongs on the range you are defining, not the function.

share|improve this answer
    
Cheers mate, this works. –  Joao Ferreira Dec 27 '11 at 13:06
add comment
=COUNTIF(Alunos!myTableName[AnoInscr], "2008")

Assuming that

  • Alunos is the name of sheet.
  • myTableName is the name of the table.
  • AnoInscr is the name of the column inside table myTableName.
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.