This a typical sample:

A B C

4 1 10
4 2 22
3 1 25
4 5 30
AND is 2 in column b


Thank for your help
Clean is not said you what.
OR,
Please say it another way.
2 is located at B2 if copy pasted just the data into excel. B is the Row Location and 2 is the Line Location. So @sum(B2+B3) would show 3 in whichever cell the formula is located in and @sum(C1:C4) would show 87 in whichever cell it is located in. ( : ) is used to select a RANGE of data to sum up without having to say @sum(C1+C2+C3+C4)

2 is in fact in column B to answer your question.

* Easier way to REPRESENT your data would be to show the Line and Column indicators as shown below:

A B C D E
1 4 1 10
2 4 2 22
3 3 1 25
4 4 5 30
5
6
7

*I learned how to do all this on Lotus-123 many many years ago, and continued to use Lotus @sum instructions with Excel in which Excel will understand it and flip it to =sum. You can use EITHER as long as its interpreted in future releases of Excel etc. Even Open Office understands @sum to be =sum. It's probably more correct to use =sum, however by habbit I am quick with using @sum even though it REQUIRES extra shift-hold +2 to type the @ sign.DaveLembke, how did nyou do that?
I mean, how did you know what he wanted?