Formulas in Excel
 

I am trying to add the number of 2's, 3's, 4's, 5's, 6's in a column and put
the totals of each in another worksheet. Example if there are 6 number 4's in
a column, the answer should be 6. I also want this answer to go on another
worksheet.

Formulas in Excel
 

You need to use the Countif function.


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=559339

Formulas in Excel
 

Whitney

Check out the FREQUENCY function in Help. There are examples there.

You will need a data range for the column of numbers and a bins range of
2,3,4,5,6 in 5 cells in another column.

Note: the formula must be entered as an Array formula so CTRL + SHIFT + ENTER
is needed.


Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 07:26:02 -0700, Whitney
wrote:

I am trying to add the number of 2's, 3's, 4's, 5's, 6's in a column and put
the totals of each in another worksheet. Example if there are 6 number 4's in
a column, the answer should be 6. I also want this answer to go on another
worksheet.