Hi,

Do you mean this

=SUMPRODUCT((A2:A5=E2)*(C2:C5))

Mike

"Spheon" wrote:

=IF(ISNA(VLOOKUP(E2,$A$2:$C$5,3,FALSE)),0,VLOOKUP( E2,$A$2:$C$5,3,FALSE))

Hi I have managed to get this formula to work but I dont want the result to
end at the first find, I want to find all that are the same as E2 in range to
sum all in column 3.

Is this possible, I dont really want to create a pivot table and getdata
etc, surely there is a way but I am scratching my head :(

thanks in advance