Look at SUMIF

=SUMIF(A:A,"Despain",I:I)

Regards

Trevor


"Annabelle" wrote in message
ups.com...
I need to sum all numbers in column i18:i300 that have "Despain" in
column A. Can you assist?

EXAMPLE:
Column A Column I
Despain 2.5
Jones 5.0
Smith 2.0
Smith 4.0
Despain 3.0
Johnson 1.5
Despain 2.0

RESULTS:
Despain = 7.5
Johnson = 1.5
Jones = 5.0
Smith = 6.0