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

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.
Similar Threads
  1. Riyaz

    If not blank

    Riyaz, Dec 6, 2011, in forum: Excel
    Replies:
    0
    Views:
    528
    Riyaz
    Dec 6, 2011
  2. DPCpresto

    Excel icon doesn't work.

    DPCpresto, May 2, 2012, in forum: Excel
    Replies:
    0
    Views:
    351
    DPCpresto
    May 2, 2012
  3. DPCpresto
    Replies:
    0
    Views:
    637
    DPCpresto
    Aug 16, 2012
  4. Russ56

    Margins not printing correctly

    Russ56, Feb 25, 2014, in forum: Excel
    Replies:
    0
    Views:
    667
    Russ56
    Feb 25, 2014
  5. vahid
    Replies:
    0
    Views:
    292
    vahid
    Apr 21, 2015
  6. Pete Marsh
    Replies:
    0
    Views:
    279
    Pete Marsh
    Nov 26, 2015
  7. tcebob

    Sum data using sumif

    tcebob, Jan 26, 2016, in forum: Excel
    Replies:
    3
    Views:
    248
    tcebob
    Jan 29, 2016
  8. tcebob

    Sumif using partial string

    tcebob, Mar 7, 2016, in forum: Excel
    Replies:
    7
    Views:
    379
    Amy @ German Pearls
    Mar 12, 2016
Loading...