I need some help regarding excel.
Below is my data.
CodeFigure04-0070G509,19004-009014,67204-011015,00004-0130(100,000)04-0140(8,032)04-0150(80)04-0170(171,563)0401-C0011-51-02380402-C0001-51-01450403-C0001-51-370
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
Bookmarks