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

Countif() will work

i.e. =countif(B1:B100,"&LT;15")

HTH
Jacob