SUMIf Unique Values

**aftabn10** · 03-30-2009, 08:41 AM

Hi, I have got a workbook where i need to calculate the total time taken for all users to give a total for the manager. I have wrote the following formula:

=SUMIF(A2:A9,F2,C2:C9)

but this totals all the values including the duplicate times. What i would like is to sumif only the unique values within column c for a unique user. i have attached a sample workbook. Could somebody please help.

Thanks in advance.

**NBVC** · 03-30-2009, 08:45 AM

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear around the formula.

If you adjust the ranges, you will need to re-confirm with CSE keys combo.

**aftabn10** · 03-30-2009, 10:28 AM

Thanks for your reply NBVC, i will try that and see how i get along.

Thanks once again.

**NBVC** · 03-30-2009, 10:29 AM

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**depple** · 04-16-2009, 03:56 AM

Hi,

Great solution! It is though beyond my understanding of Excel formulas.

. But, the lack of understanding is not my issue:

I have a similar problem, though maybe a little more advanced. I would like to do the exact same, but when looking at the sample.xls above, my data can have zero values/blank in the C-column. For instance, if C6 is blank, then the formula will not add the value in the next row. In many cases this would easily be solved through sorting, but the structure of my sheet do not allow for this. So what I am looking for, is a formula for only regarding rows where the cells in column C is <>"".

Maybe this cannot be done in a single formula, and has to be solved through VBA, but having seen some incredible solutions here, I thougth I'd give it a try.

**DonkeyOte** · 04-16-2009, 04:09 AM

depple, please read all forum rules... do not hijack the threads of other members, please ask your own question in your own thread... if you wish to refer to this thread add a link to it in your own.

EDIT: depple's thread: http://www.excelforum.com/excel-gene...-criteria.html