Trying to have multiple cells deduct from one cell when the integer being deducted is represented by a letter.

[Mortamus]

i want to take C3:I10 and deduct a number from B2 if the value in C3:I10 is(number) represented by a letter. i.e. c3:I10 would be represented by "x" the value of "x" being 6 and it being taken from b2 which has the number 250 in the cell. ive tried sum, sumif, nested if, you name it and i get ziltch.

 

[dreid1011]

Can you post sample data of what C3:I10 looks like? You can use the XL2BB addin to do this. And explain how/when "x" should be deducted from B2.

 

[Mortamus]

we aren't permitted that kind of add in at my company. basically is what i am wanting is if any of the cells in that range has an x in it, it will subtract the number that x represents from the number that is in cell B2.

 

[Joe4]

Your explanation is hard to understand without seeing your data. Perhaps you show us an image of your data?
I have the same limitation regarding add-ins at my company, so I often use screen prints myself (using the Windows Snipping tool, though you could use screen prints too).

 

[dreid1011]

Okay, I imagine something like this, however, beyond B2 and C3:I10, I can only guess at your layout:

Book1
	A	B	C	D	E	F	G	H	I
1
2		250	x=	6
3		190	x						x
4							x
5						x
6					x
7				x
8			x
9							x	x
10									x
11								x Count:	10
Sheet3

Cell Formulas
Range	Formula
B3	B3	=B2-(COUNTIF(C3:I10,"x")*D2)
I11	I11	=COUNTIF(C3:I10,"x")