Function of sum

Joined
Jul 15, 2010
Messages
1
Reaction score
0
I wonder if has a function that you can add a column but obeying the criteria of another column. Ex:
___C___D___E___ F
2...xx__10_______30
3...yy__15
4...xx__20
5...yy__25
6...zz__30
...
...
n...zz__35

Then , in F2, obtain the sum of column D for all values in column C with "xx". (In case: 10 + 20 = 30)
Thanks
Luiz Melo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top