Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel considers my formulas as plain text | Excel Worksheet Functions | |||
How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) |