=SUMIF(A:A,"Z",B:B)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Yuki" wrote:

Hi all!

I need a help to make a function to do some work for me.
In my worksheet, I have two columns. The first is about descriptions, and
the second about values.
Like this:
A B
1 Z 1
2 Z 3
3 Y 2
3 Z 8

So, I need to put in a cell, the sum of the values which have description
equal 'Z'.

Somebody could help, please?

Thanks!