I know how to do the basics, sums, counts, averages.... But I have a spreadsheet that has several culumns with each row being a different date. I need to set up formula's in cells off to the side that take a sum or average from numbers in one column, but not all the numbers just the ones in certain rows. For example if I had a column of names, and a column of numbers. I would need to get the sum from the colum of numbers for a certain name only. That name appearing several times, not just once, in the column of names along with many other names in that same column. It's more complicated then that since I would have do this with several different columns that are names, locations, and various other info that happened on each date but if you could tell me a formula command to do this that would be great.

=sumif(range, criteria, sumrange) Also, look at the whole database section of functions. They all begin with "d", e.g. dcount, dsum, dmin, dmax, dget, etc.