pickup cell value according another cell value
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. |
=SUMIF(Sheet1!A1:A100,"Total",Sheet1!D1:D100)
-- HTH RP (remove nothere from the email address if mailing direct) "Maileen" wrote in message ... 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. |
thanks a lot,
it works great. maileen. Bob Phillips wrote: =SUMIF(Sheet1!A1:A100,"Total",Sheet1!D1:D100) |
All times are GMT +1. The time now is 04:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com