adding the cells with unique values

[stoey]

hi everyone,

can some one help me how to add the unique cell values using the formula bar?
like if on column C i would like to add all the row values which have the name "George" how can this be possible using the formula bar?

Attached is a sample file.

Thanks,

Stoey

[DonkeyOte]

A few options, one

D7: =SUMIF($C$14:$C$27,$C7,$F$14:$F$27)
copied down
(ensure the names in C7 etc reflect those used in the table below)

Other option would be to use a Pivot Table (see link in Sig.)

[stoey]

hi DonkeyOte,

thanks for the quick reply...my bad for not explaining well...can this be done using if and else method? like if the cell value is equal to "George" then add the cell value within the row of George...by the way i forgot that I am using list for the names indicated. attached is a new file with the list method.

thanks,

stoey

[DonkeyOte]

I'm afraid I don't understand the question, if you wish to conditionally sum values in your 2nd table you should (as outlined) be using SUMIF function (or Pivot Table).

[martindwilson]

works fine for me there is something strange preventing it add correctly though reselect all your names from the drop downs the names currently in cells have spaces after some of them

[stoey]

hi again,

im sorry to confuse you...here's how it goes...on column C: i have a list of names, on column F i have time rendered....what I would like to do in D7 is to compute the time rendered occured under the name "George". I understand the fact that I can manually enter, the column or row number to get the sum, but the name "George" appears in different row of column C in which i'll be manually changing the formula should the name "George" appears on different row of column C. How can I create a formula such that it will compute the time rendered under the occured name "George"? can this be done using index, match or offset? if yes, can you please show me how?

Thanks,

Stoey

[martindwilson]

use the formula donkeyote provided

[Ron Coderre]

Per your posted workbook....
The names in C14:C28 have trailing spaces, whereas the target name in c7 does not.

Try one of these formulas:

Please Login or Register  to view this content.

That cell should be formatted as TIME.

Does that help?

[stoey]

hi everyone,

this forum really rocks!...thanks Ron, Donkey and martin...got the formula working! You guys are totally awesome. Thanks again

Regards,
Stoey