Counting Numbers in Column

[adrian5]

OK. Say i have three columns. ID, NAME, AGE. I want to count all the ages in the AGE column and add them up. How?

Thanks :thumbsup:

[NancyJ]

SELECT SUM(Age) as sumofages, COUNT(age) as numofages FROM table