Return and non-duplicate SUMIF data

How could I have seen VBA, the data in column "A" no duplicates in the column "E" and the sum of these criteria in column "F".

See Attachment

Thank's

Hi use builtin function of excel in VAB

Please Login or Register  to view this content.

I think You can adjust it to your needs

Not so.

the code needs to go céluas of the column a "A" and see how many I have different data.

then he sends this reultado to column "E" is the code I have found that 3 data only ones he will return me the total of each column as one "F" under the column "E".

It was great!

But is giving the end of the column "E" value of 633.4

in my case I do not have value.
can eliminate this part?
it can also comment on the code, I am grateful

try this

Please Login or Register  to view this content.

works only with ex>2007

Look into your file column A row 64

Thank you!!!

thank you both!

Thank you very much!

Why do you want VBa for this?
In E2

Please Login or Register  to view this content.

In F2

Please Login or Register  to view this content.

Drag/Fill both Down

If anyone can comment codes be very grateful!

nilem could you comment your code?