Function for adding cells together but multiplying cells if "contains x text"

[darkshotguns]

Dont know if it's possible, but I'm trying to find a formula for excel. Looking to add multiple cells together, but double certain cells if another cell has certain text. My spreadsheet will update depending on the data. (Example Cell A1, may have an "X" or "Dot" in the cell depending on Cell B1.) (I need to add up all the cells in B1-B20, but double certain cells if Cells a1-A20 contain certain text.)

 

[Eric W]

Welcome to MrExcel.

How about:

Book1
	A	B	C	D
1		1		245
2		2
3		3
4	x	4
5		5
6	x	6
7		7
8		8
9		9
10	x	10
11		11
12		12
13		13
14		14
15	x	15
16		16
17		17
18		18
19		19
20		20
Sheet3

Cell Formulas
Range	Formula
D1	D1	=SUMPRODUCT(B1:B20,(A1:A20="x")+1)

 

[darkshotguns]

I had to do some overhauling of how the cells were laid out, but the formula worked. thank you.

 

[Eric W]

Glad it worked for you. Thanks for the update.