Changing part of a formula

  • Thread starter Thread starter Hankjam
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing rows using formulas with variables 1
Sum Formula with variable range 2
Copying part of a cell 2
Sum Formula 4
Sum Formula 2
Sum parts of a column 2
summing part of data range 3
Need help with a SUM formula... 7

Back
Top