sumif does not work

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

  1. msnarayanan

    msnarayanan

    Joined:
    Aug 19, 2016
    Messages:
    5
    Likes Received:
    0
    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:
    24
    Likes Received:
    8
    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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Riyaz

    If not blank

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

    Excel icon doesn't work.

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

    Margins not printing correctly

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

    Sum data using sumif

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

    Sumif using partial string

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