You can use the SUMIF function

=SUMIF(A:A,"=Z",B:B)

--
If this post helps click Yes
---------------
Jacob Skaria


"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!