+ Reply to Thread
Results 1 to 2 of 2

Sumif where a column has segmented numbers

  1. #1
    Registered User
    Join Date
    07-22-2005
    Posts
    15

    Sumif where a column has segmented numbers

    I have two columns of figures (1 is segmented) and wish to sum column "B" if a number in the segmented column 'A' fits criteria. I need to tell the program that it needs to look at just the third segment of the Column 'A' . Eg if the third seg states 05 it sums the corresponding $value in column 'B'.
    Can anyone help?
    Column A Column B
    2-10-05-3628-701 $19.00
    2-10-05-3179-701 $19.00
    2-10-05-3628-701 $8.35
    2-10-05-3179-701 $8.35
    2-10-05-3628-701 $9.85

  2. #2
    Registered User
    Join Date
    07-22-2005
    Posts
    15

    Re: Sumif where a column has segmented numbers

    I have solved my own problem. Thanks.
    My solution
    =SUMIF(A1:A17,"*-*-04-*-*",B1:B17)

+ 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