Thanks a lot Joel will do and will let you know how I go in a few days as I
am going away for 4 days and will study whilst away
Derro

"Joel" wrote:

I think you just need to learn how to use SUMPRODUCT. do a searchfor
SUMPRODUCT on this website. For your case of fred

=Sumproduct(--(H1:H100="Fred"),I1:I100)