Sumif to calculate account sales?

[JLa]

I am trying to calculate total yearly sales by account, however, each account
has satellite locations. Each sale is listed in its own row of data. I have
successfully used sumproduct to caculate the quantity of the sales. Now I
need to calculate the Total Sales. Note: due to the hyphen, all account
numbers are text cells. Goal: to have a total for each main company. For
example, ABC would be $254 and XYZ would be $1170.

A B C
123-000 ABC North $99
123-001 ABC South $30
123-002 ABC East $25
123-003 ABC West $100
456-000 XYZ HQ $85
456-001 XYZ Midwest $55
456-002 XYZ Central $23
456-003 XYZ East $1007

 

[mzehr]

Hi,
Try
=SUMIF($B$1:$B$8,"ABC"&"*",$C$1:$C$8)
=SUMIF($B$1:$B$8,"XYZ"&"*",$C$1:$C$8)

Or consider using a helper column to strip out the first 3 letters of the
satellite, and use a pivot table to summarize for you.

 

[Frank Kabel]

Hi
can't you first convert your 'Text values' to real numeric values. e.g.
by copying an empty cell and pasting it with 'Edit - Paste Special' -
Addition

 

[Aladin Akyurek]

=SUMIF($B$2:$B$100,E2&"*",$C$2:$C$100)

where E2 houses a criterion value like ABC.