Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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. |
#3
|
|||
|
|||
thanks a lot,
it works great. maileen. Bob Phillips wrote: =SUMIF(Sheet1!A1:A100,"Total",Sheet1!D1:D100) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |