Sum data using sumif

[tcebob]

I have a 2-column list of names and values:
StoreA Produce| 25.00
StoreC | 15.00
StoreA Dairy | 17.50
StoreD | 8.24
etc...

I'd like to sum all the values from Store A with a single formula.

So far I have made a separate column, using the formula
=IF(ISNUMBER(SEARCH("StoreA",$B29)), $D29,"------")
Which can be summed using Sum.
I'm pretty sure this can be replaced with a Sumif but I can't seem to get the right expressions.

Using Excel 2004, Win 10.

 

[tcebob]

P.S. Can someone tell me how to format columnar text in this forum? I set it up in a mono font but the system removes extra spaces.

 

[Becky]

Yep, that's possible. You can use SUMIF as follows:

=SUMIF(A2:A5,"Store A",B2:B5)

Where A2:A5 is the range of cells which contain the different store names, and B2:B5 is range with the corresponding values. I've just used 2 to 5 for the illustration.

Is that what you are looking for?

 

[tcebob]

Thanks much, Becky. Worked fine.