Hi,

I have a column (for example A) in which sometime it is written "Total".
In another column (for example D) but on the same row than "Total", I have
the value of this Total.

What i would like to do is :

to scann all A column and everytime that i found "Total", I would like to
get the value stored into colum D..

after collecting all values of totals, i will add them to 1 cell (to another
sheet).
for example,

A5 = Total, D5 = 25100
....
A41=Total, D41=15455


how can i do that automaticaly without doing macro ?

thanks a lot,
Maileen.

You almost wrote the formula while explaining the question

put this formula in d1 : =if(a1='TOTAL',your value,"")

your value is the value you want in d1.

Then simply pull down the formula in the whole column.

"Maileen" wrote:

Hi,

I have a column (for example A) in which sometime it is written "Total".
In another column (for example D) but on the same row than "Total", I have
the value of this Total.

What i would like to do is :

to scann all A column and everytime that i found "Total", I would like to
get the value stored into colum D..

after collecting all values of totals, i will add them to 1 cell (to another
sheet).
for example,

A5 = Total, D5 = 25100
...
A41=Total, D41=15455


how can i do that automaticaly without doing macro ?

thanks a lot,
Maileen.

Maileen,

=SUMIF(A1:A8,"=Total",D1:D8)

Place the formula in the cell you want the Total of totals to be in. Change
the range to fit your spreadsheet. NOTE: The text "Total" shouldn't be case
sentitive, but try to keep it consistant anyway.

Mike

"Maileen" wrote:

Hi,

I have a column (for example A) in which sometime it is written "Total".
In another column (for example D) but on the same row than "Total", I have
the value of this Total.

What i would like to do is :

to scann all A column and everytime that i found "Total", I would like to
get the value stored into colum D..

after collecting all values of totals, i will add them to 1 cell (to another
sheet).
for example,

A5 = Total, D5 = 25100
...
A41=Total, D41=15455


how can i do that automaticaly without doing macro ?

thanks a lot,
Maileen.