Comparing two cells and adding data

[trackyourplays]

Hi Excel experts!
I am a newbie 100%...

I am trying to get Excel to look at two cells and if they match, add data from a third cell into a fourth cell. The fourth cell will need to add together any data put into it.

So, cell a1 has a value of 8, cell a2 also has a value of 8. Since they match, I need the value from cell a3 (12.60) a4 (6.20) and a5 (9.80) to be added together in cell a6 for a total of 28.60.

If the cells do not match, no data movement is necessary; I guess it will just stop there.

Any ideas? Thank you!

[mehmetcik]

Please Login or Register  to view this content.

[trackyourplays]

Thank you! That was perfect!