Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

SUMIF

Discussion in 'Information Technology' started by Mad Dog, Jul 28, 2006.

Tags:
  1. Mad Dog

    Mad Dog
    Expand Collapse
    Guest

    Hello.

    I want to run a SUMIF command but once the criterion is met, I want to add
    values in a range that cuts across columns. Here's an example:

    =SUMIF(F2:F13,63800,B2:C13)

    That formula isn't working for me. Can you help?

    Thanks,
     
  2. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    You have posted your question in Microsoft Access discussion group and it
    sound like Excel question, if I'm right try Microsoft Excel discussion group
    at this link

    http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US
    --
    Good Luck
    BS"D


    "Mad Dog" wrote:

    > Hello.
    >
    > I want to run a SUMIF command but once the criterion is met, I want to add
    > values in a range that cuts across columns. Here's an example:
    >
    > =SUMIF(F2:F13,63800,B2:C13)
    >
    > That formula isn't working for me. Can you help?
    >
    > Thanks,
     
  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    You may want to ask this question in an Excel newsgroup which is more
    appropriate to your problem. This newsgroup is dedicated to the Microsoft
    Access database product. The Microsoft website is not all that clear and may
    have misdirected you.
    --
    Arvin Meyer, MCP, MVP
    Free MS-Access downloads:
    http://www.datastrat.com
    http://www.mvps.org/access
    http://www.accessmvp.com

    "Mad Dog" <MadDog@discussions.microsoft.com> wrote in message
    news:C3204F4F-0664-4E2F-940E-314FED77EAD2@microsoft.com...
    > Hello.
    >
    > I want to run a SUMIF command but once the criterion is met, I want to add
    > values in a range that cuts across columns. Here's an example:
    >
    > =SUMIF(F2:F13,63800,B2:C13)
    >
    > That formula isn't working for me. Can you help?
    >
    > Thanks,
     

Share This Page