Sum column based on another column criteria
 

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

Sum column based on another column criteria
 

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

Sum column based on another column criteria
 

Hi Annabelle,

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

should do the job ...

HTH
Cheers
Carim

Sum column based on another column criteria
 

Thanks you both!

Carim wrote:
Hi Annabelle,

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

should do the job ...

HTH
Cheers
Carim