Formula that will return the adjacent cell

[Scarle]

I am trying to write a formula/function so that if a certain cell has a specific text it will add all adjacent cells and give a total dollar amount?

I have uploaded an example
Ex.) so how do I get a total dollar amount for Lowes?

[Jonmo1]

Sounds like sumif

=SUMIF(A1:A100,"Lowes",B1:B100)

That will sum values in B1:B100 where "Lowes" exists in A1:A100

[Pete_UK]

Can't see your example file, but you can probably use SUMIF for this.

Hope this helps.

Pete

[alansidman]

No file uploaded. Here are instructions on how to do it.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Tony Valko]

I don't see a link to a sample file.

Try something like this:

Data Range

	A	B	C	D	E
2	Lowes	56	-----	Lowes	170
3	Penneys	33
4	Lowes	83
5	Lowes	23
6	WallMart	56
7	KMart	80
8	Sears	48
9	Sears	81
10	Lowes	8

This formula entered in E2:

=SUMIF(A2:A10,D2,B2:B10)

[Scarle]

That worked great! Thanks! One more question does case matter? Lowes, lowes, LOWES?

[Jonmo1]

No, it's NOT case sensitive.

[Tony Valko]

That worked great! Thanks! One more question does case matter? Lowes, lowes, LOWES?

No, case does not matter.

[Scarle]

Excel example.xlsxhere is file

[Scarle]

Thanks again!!!!!

[Jonmo1]

You're welcome.

[Tony Valko]

You're welcome. Thanks for the feedback!