Help with Excel formula's

Discussion in 'General Software' started by theTIK, Sep 21, 2004.

  1. theTIK

    theTIK Gawd

    Messages:
    757
    Joined:
    Jul 3, 2003
    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.
     
  2. pbj75

    pbj75 Limp Gawd

    Messages:
    208
    Joined:
    Sep 30, 2003
    =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.
     
  3. theTIK

    theTIK Gawd

    Messages:
    757
    Joined:
    Jul 3, 2003
    Thank you that was very helpful.