Sum column based on another column criteria

A

Annabelle

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
 
C

Carim

Hi Annabelle,

=SUMIF(A18:A300,"=Despain",I18:I300)

should do the job ...

HTH
Cheers
Carim
 
Top