Results 1 to 5 of 5

Reading in Number Strings with Dashes in SUMPRODUCT

Threaded View

rackun Reading in Number Strings... 04-22-2008, 10:11 PM
Portuga You can use a sumif formula:... 04-22-2008, 11:30 PM
rackun That won't work if I want to... 04-23-2008, 12:27 AM
mikerickson This variation will count all... 04-23-2008, 12:52 AM
rackun I can't be adding on forever... 04-23-2008, 01:50 AM
  1. #1
    Registered User
    Join Date
    04-22-2008
    Posts
    3

    Reading in Number Strings with Dashes in SUMPRODUCT

    I need some help regarding excel.
    Below is my data.

    Code
    Figure
    04-0070G
    509,190
    04-0090
    14,672
    04-0110
    15,000
    04-0130
    (100,000)
    04-0140
    (8,032)
    04-0150
    (80)
    04-0170
    (171,563)
    0401-C0011-51-0
    238
    0402-C0001-51-0
    145
    0403-C0001-51-3
    70

    04-1090
    (13,164)

    I need to get the total figure of items with the codes ranging from 0401 to 403.
    I tried using =sumproduct((code>="0401")*(code<="0403")*(figure)).
    Code 04-0110 to 04-0170 are also read into the data range because 04-01 is read in as 0401.
    Is there any way to rectify the problem or is there any other ways to read in the range to get the total?
    I cannot change the codes as they are fixed.

    Thank You
    Last edited by rackun; 04-22-2008 at 10:19 PM.

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