Hello,

I'm trying to make a macro that will add (and show the sum) of some values in column D, IF their values in column A are the same. (all the A's in one group, the B's in another, etc)
Let me show you:



Therefore, if the cell in column A is an A, I would like it to add the values of the cells in column D, and display them in F2
Then add all the B's values into G2
and so on.
So it would look something like this:



Is this possible? It's the only remaining piece in this big project, and I can't find the solution anywhere...

Thank you for your time,
Danniel

Whew, sorry that it has been so long for this post, I need to visit the computer software forum more often!

The SUMIF() function should do what you need.

So, for your example data, keeping cells F1, G1, H1, and I1 populated with A, B, C, and D, respectively [to use as a SUMIF argument reference], then the formula using SUMIF in cell F2 would simply be:

=SUMIF($A$8:$A$24,F1,$D$8:$D$24)

Then simply fill this formula to the right three cells ( G2, H2, and I2) and the 2nd argument will automatically adjust!
HTH

Feel free to ask any Q!

__________________
Use the force...read the source!!
WYCIWYG -- what you code is what you get!