Multiply a cell only if there is a vale and add it to some other cell

[tescatlipoca]

It seems confusing but should be simple even I can't find a way to get it done

Basically I have:

column B with values (estimated Duration)
Column C to L I have markers in the cells either "x" or ""

What I want is to automate a way at the end of each Column C to L (Totals)

If there are "x" markers on column C find the responsive cell in Column B and add all those to the end of Column C same for Column C to L

I do appreciate all the help.

Thank you.

 

[jtakw]

Hi,

Something like this?

Excel 2010
	B	C	D
1	estimated Duration
2	1		x
3	2	x
4	3		x
5	4		x
6	5	x
7	6		x
8	7	x	x
9	8	x
10	9		x
11	Totals	22	30
Sheet1

Cell Formulas
Range	Formula
C11	=SUMIF(C2:C10,"x",$B2:$B10)

Formula copied across from Column C to L

 

[tescatlipoca]

Thank you much! Appreciate it!

 

[jtakw]

You're welcome, welcome to the forum.