CountIf Q

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to count up the number of times a certain value appears in a
column. This value is in a List so I want to reference where it is in the
list within my formula. I've tried the following but its wrong

=COUNTIF(C$7:C$402,A405)

Where A405 is the value I want to count if they are in C7: C402

Thanks
 
John said:
I am trying to count up the number of times a certain value appears in a
column. This value is in a List so I want to reference where it is in the
list within my formula. I've tried the following but its wrong

=COUNTIF(C$7:C$402,A405)

Where A405 is the value I want to count if they are in C7: C402

Thanks
Click to expand...
You say "Iam trying to count up the number of times a cerain value
appears in a column." =COUNTIF(C$7:C$402,"A405")

You say on the other hand "I want to reference where it is in the list."
=MATCH("A405",C$7:C$402,0)

You said "Where A405 is the value I want to count." If instead you meant
that the value in Cell A405 is the value you want to count, remove the
quotes around it.

Alan Beban
 
Back
Top