MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula for counting 1's & 2"s


Posted by Paul Magruder on April 19, 2001 12:01 PM

Is there a formula that will let me count the number of 1's in a column (b1:b7)? Also need the number of 2's but I Can do that seperatly if necessary.

Thanks in Advance
Paul


Posted by Mark W. on April 19, 2001 12:03 PM

=COUNTIF(B1:B7,1)

Posted by Aladin Akyurek on April 19, 2001 12:03 PM


=COUNTIF(B1:B7,1)
=COUNTIF(B1:B7,2)

Aladin

Posted by Ian on April 19, 2001 12:04 PM

Aladin, you're slowing down!

Posted by Mark W. on April 19, 2001 12:09 PM

Re: Aladin, you're slowing down!

What's 5 seconds among friends? ; ) :