sumif does not work

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

  1. msnarayanan

    msnarayanan

    Joined:
    Aug 19, 2016
    Messages:
    29
    Likes Received:
    1
    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:

    =sumif($b$2.$b$12,"cash",$c$2.$c$12)

    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
    1. Advertisements

  2. msnarayanan

    Amy @ German Pearls

    Joined:
    Feb 2, 2016
    Messages:
    25
    Likes Received:
    9
    The start and end of the ranges should be separated by a colon :)) not a period (.). Other than that, looks good.
    =sumif($b$2:$b$12,"cash",$c$2:$c$12)
     
    Amy @ German Pearls, Nov 15, 2016
    #2
    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.