MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Trying to figure out a Formula


Posted by Darrin on January 05, 2002 5:23 PM

I am trying to but a colunm in to different categories. Such as up to 15 years old, 16 to 25 years Etc. I can get the formula to include the colunm but I can only get the the first entry to work. it will not "add" up the different catergories. please help.

Thanks


Posted by Jacob on January 05, 2002 9:35 PM

Hi

Countif() will work

i.e. =countif(B1:B100,"<15")

HTH
Jacob