Recalling multiple variables

[AssignmentHelp]

Hello forums,

My problem is IÂ’m trying to recall multiple variables in a row to the end of a column. For example, my table will look like this:

A. B. C. D. E. F. G. H
1) Model. Worktop Time Door time Drawer Time Total subs
2). a. 0. 0m 1. 5m. 2 3m. Formula
3). b. 1. 5m. 2. 10m. 0. 0
4). c. 1. 0. 1. 5m. 2. 0

I have Models A, B, and C. Each model gets a sub assemblied piece added to it. (And some may not have a time). IÂ’m trying to write an if/then statement saying if there is a time >0, recall the value for that piece into the total sub cell. If there is no time, donÂ’t recall anything or recall 0. But i want to string it or nest it all into one formula.

So, the formula might look like this: =if(c2>0, then recall b2 into h2, else, recall 0 into h2, if(E2>0, recall D2 into H2, else, 0, if(etc....))).... and if i copied it paste it down the column it will change the formula according to whatever row itÂ’s in.

Ive tried [if/then(vlookup)], sumifs, counts; not really sure anymore.

I hope this makes sense. Thanks in advance.


EDIT: Sorry, didn’t realize my table would look like that after i submit it

 

[sijpie]

What about:

in H2:
=IF(C2,B2,0)+IF(E2,D2,0)+IF(G2,F2,0)

	A	B	C	D	E	F	G	H
1	Model	Worktop	Time	Door	Time	Drawer	Time	Total subs
2	a	0	0 m	1	5 m	2	3 m	3
3	b	1	5 m	2	10 m	0	0 m	3
4	c	1	0 m	1	5 m	2	0 m	1

<colgroup><col style="width:48pt" span="9" width="64"> </colgroup><tbody>
</tbody>

 

[sijpie]

By the way, to show a piece of worksheet in a table like above, copy the range from Excel. Then in the formatting icons (in Reply you have to go to 'Go Advanced') look for the table icons and select the table property icon. Then select all gridlines there.