Possibly

=SUMPRODUCT((A1:A20="Myword")*(B1:B20))

Mike

"Mick" wrote:

Hi,

I would like to create some formulas that regonises a word in the first
column and then adds up the number across from it.

Thanks....
--
MickM