Formulas in Excel

W

Whitney

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

Gord Dibben

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
 
Top