sumif does not work

Discussion in 'Excel' started by msnarayanan, Aug 23, 2016.

  1. msnarayanan


    Aug 19, 2016
    Likes Received:
    dear all

    i have created 4 tables which contains common fields
    /names such as cash, printing, donations etc.

    in a particular table, i had created a drop down from a list in other table. for entering
    the data there is no problem. in another column i enter amounts.

    problem arises which i used the following formula it does not work:


    should i change the formula, and if so how.

    please note the range/names are taken from another table.

    m s narayanan
    msnarayanan, Aug 23, 2016
    1. Advertisements

  2. msnarayanan

    Amy @ German Pearls

    Feb 2, 2016
    Likes Received:
    The start and end of the ranges should be separated by a colon :)) not a period (.). Other than that, looks good.
    Amy @ German Pearls, Nov 15, 2016
    Becky likes this.
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.