CountIf Q

's Computer Specifications

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

's Computer Specifications

Got it

"John" <(E-Mail Removed)> wrote in message
news:jyt6d.32368$(E-Mail Removed)...
> 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
>
>
>

's Computer Specifications

It works fine for me, John. With letters or numbers.
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************
"John" <(E-Mail Removed)> wrote in message
news:jyt6d.32368$(E-Mail Removed)...
> 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
>
>
>

's Computer Specifications

John wrote:

> 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
>
>
>
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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF is Off by 1	GooseMA	Microsoft Excel Misc	4	8th Dec 2009 05:04 PM
Can I use COUNTIF with OR?	AA Arens	Microsoft Excel Discussion	3	20th Nov 2006 04:11 PM
How do I use a countif function according to two other countif fu.	=?Utf-8?B?S2lyc3R5?=	Microsoft Excel Worksheet Functions	2	20th Feb 2006 11:44 AM
COUNTIF or not to COUNTIF on a range in another sheet	=?Utf-8?B?RWxsaWU=?=	Microsoft Excel Worksheet Functions	4	15th Sep 2005 10:06 PM
COUNTIF in one colum then COUNTIF in another...???	=?Utf-8?B?Sm9ubmllUA==?=	Microsoft Excel Worksheet Functions	3	22nd Feb 2005 02:55 PM