+ Reply to Thread
Results 1 to 5 of 5

Excel 2003 multiple criteria

  1. #1
    anike007
    Guest

    Excel 2003 multiple criteria

    I am trying to add numbers in column H IF the data in column E=AS FIN AND the
    data in column B=Jan

    I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.

    Thanks for any help you can provide.

  2. #2
    Toppers
    Guest

    RE: Excel 2003 multiple criteria

    Is this what you want?

    =SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))


    "anike007" wrote:

    > I am trying to add numbers in column H IF the data in column E=AS FIN AND the
    > data in column B=Jan
    >
    > I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.
    >
    > Thanks for any help you can provide.
    >


  3. #3
    anike007
    Guest

    RE: Excel 2003 multiple criteria

    Hmmmm - I've tried SO many things but I can't seem to get anything to work....


    I tried this but come up with a #Value! answer?!?!?!?!?

    Toppers wrote:
    >Is this what you want?
    >
    >=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))
    >
    >> I am trying to add numbers in column H IF the data in column E=AS FIN AND the
    >> data in column B=Jan
    >>
    >> I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.
    >>
    >> Thanks for any help you can provide.


  4. #4
    Dave Peterson
    Guest

    Re: Excel 2003 multiple criteria

    Check for #Value! errors in E1:E100l and B1:B100.

    Check for non-numeric entries in H1:H100.

    anike007 wrote:
    >
    > Hmmmm - I've tried SO many things but I can't seem to get anything to work....
    >
    > I tried this but come up with a #Value! answer?!?!?!?!?
    >
    > Toppers wrote:
    > >Is this what you want?
    > >
    > >=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))
    > >
    > >> I am trying to add numbers in column H IF the data in column E=AS FIN AND the
    > >> data in column B=Jan
    > >>
    > >> I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.
    > >>
    > >> Thanks for any help you can provide.


    --

    Dave Peterson

  5. #5
    anike007 via OfficeKB.com
    Guest

    Re: Excel 2003 multiple criteria

    URGH!!!! So frustrating. Still not working.... ??? :-(

    I've checked everything I know to check?? Thanks for trying!

    Dave Peterson wrote:
    >Check for #Value! errors in E1:E100l and B1:B100.
    >
    >Check for non-numeric entries in H1:H100.
    >
    >> Hmmmm - I've tried SO many things but I can't seem to get anything to work....
    >>

    >[quoted text clipped - 10 lines]
    >> >>
    >> >> Thanks for any help you can provide.

    >


    --
    Message posted via http://www.officekb.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1