Changing part of a formula

H

Hankjam

Hello

I have a =sum formula:

=SUM('C:\Documents and Settings\Andrew\Desktop\CHK2
minaturisation\[03_Dec07_0243.txt]03_Dec07_0243'!$B$119:$M$126)

that totals the values of an 12 by 8 range.

I would like to have a column of the variables

0243
0244
0245
0246

so I can get the total of each of these data files in the next column.

Could someone suggest an approach?

Many thanks

Andrew
 
W

ward376

I would like to have a column of the variables
0243
0244
0245
0246

so I can get the total of each of these data files in the next column.

Could someone suggest an approach?
Click to expand...

Try the sumif worksheet function.

Cliff Edwards
 
Top