Quick Excel formula question?

Big Limpin' · #1 10-28-2005, 03:14 AM

help! want to count a #'s occurance in a table. have a 5x4 grid of SnG finishes (1-9), and a cell that counts how many 1sts.
COUNT(A1

5) returns how many of those have a value. i want a
COUNT(IF(1,A1

5)) or something like that?
THat MS paperclip hates me.

Hope this is a one line answer from somone who didnt mind my not doing a search [img]/images/graemlins/crazy.gif[/img]

thanks, BL'

mackthefork · #2 10-28-2005, 04:31 AM

[ QUOTE ]
help! want to count a #'s occurance in a table. have a 5x4 grid of SnG finishes (1-9), and a cell that counts how many 1sts.
COUNT(A1

5) returns how many of those have a value. i want a
COUNT(IF(1,A1

5)) or something like that?
THat MS paperclip hates me.

Hope this is a one line answer from somone who didnt mind my not doing a search [img]/images/graemlins/crazy.gif[/img]

thanks, BL'

[/ QUOTE ]

Hi BL

I Think this is what you are looking for....

=COUNTIF(A1

5,1)

Regards Mack

Big Limpin' · #3 10-28-2005, 07:07 AM

=COUNTIF(A1

5,1)

Perfect! THanks bud [img]/images/graemlins/smile.gif[/img]