+ Reply to Thread
Results 1 to 4 of 4

SUMIF Problems

  1. #1
    Registered User
    Join Date
    11-13-2003
    Posts
    11

    SUMIF Problems

    I have (2) columns. I want to sum the totals in column C if a value (N) is in column D is true. My instruction is =sumif(c2:c38,"*N*",d2:d38). For some reason, it keeps coming back with 0. This is the second time I have run into this problem. Your help would be appreciated. Thank you.

    Larry

  2. #2
    pinmaster
    Guest
    Hi

    =SUMIF(D2:D38,"*N*",C2:C38)

    Regards
    JG

  3. #3
    Registered User
    Join Date
    11-13-2003
    Posts
    11

    Senior Moment

    Do not worry about this posting (SUMIF). I had a 'senior moment' and did not realize that I was reversing the cells to sum and locate. Thanks anyway.

  4. #4
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote Originally Posted by lkw441
    I have (2) columns. I want to sum the totals in column C if a value (N) is in column D is true. My instruction is =sumif(c2:c38,"*N*",d2:d38). For some reason, it keeps coming back with 0. This is the second time I have run into this problem. Your help would be appreciated. Thank you.

    Larry
    Try this ...

    =sumif(D2:D38,"N",C2:C38)
    BenjieLop
    Houston, TX

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1