Sum of col A, where chars in Col B = "abc"

[Craig Roberts]

Hi

I have a number of sheets of data comprising between 1700-2000 lines of
data.

I want to sum the values of one column, where the first 3 characters in the
next column for each value = "abc".

Any ideas please?

Cheers
Craig.

 

[Bob Greenblatt]

Hi

I have a number of sheets of data comprising between 1700-2000 lines of
data.

I want to sum the values of one column, where the first 3 characters in the
next column for each value = "abc".

Any ideas please?

Cheers
Craig.

Give a more specific example, and I will give a more specific answer.
Meanwhile look in help for SUMIF, and post back with any questions.

 

[Craig Roberts]

Hi Bob

There is a sheet containing 1500+ lines of data.
Column A for each line contains a real number value.
Column B for eahc line contains a project code, eg. ABC_Project_Demo or
XYZ_Saturday

I would like to look up all lines in Column B which start with "ABC", or
"XYZ" etc., and sum their values.


Cheers
Craig.

 

[Bob Greenblatt]

Hi Bob

There is a sheet containing 1500+ lines of data.
Column A for each line contains a real number value.
Column B for eahc line contains a project code, eg. ABC_Project_Demo or
XYZ_Saturday

I would like to look up all lines in Column B which start with "ABC", or
"XYZ" etc., and sum their values.


Cheers
Craig.

Then the formula placed somewhere other than column A or B would look
something like:
=sumif(b1:b1500,"ABC*",a1:a1500)