Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    new york city
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Functions & Formulas (Excel 2000/Windows 2000)

    Someone has asked me if:

    a. Excel can tell them the number of people that have contributed to a certain fund. Imagine if you will Tom, Dick and Harry. Tom gives to the fund twice, Harry gives once and Dick doesn't give at all. Is there a function that will let me know that two from my list has contributed?

    b. Is there another function to let me know that one from my list has not?

    ??? Thanks....
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Functions & Formulas (Excel 2000/Windows 2000)

    Meredith,

    I inserted a couple of worksheet functions to return the Total results.

    Brent

    I deleted my original post to format the Total Gifts as Currency.
    Attached Files Attached Files

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Functions & Formulas (Excel 2000/Windows 2000)

    Hi Meredith,
    I think the attached update to your spreadsheet will do what you want. Note that the second formula is array-entered (<ctrl-shift-enter>, instead of just <enter>).
    Cheers
    Attached Files Attached Files
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •