Recalling multiple variables

AssignmentHelp

New Member
Joined
Apr 22, 2019
Messages
1
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
 
Last edited by a moderator:

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
What about:

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

[TABLE="class: grid, width: 576"]
<colgroup><col style="width:48pt" span="9" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]A[/TD]
[TD="width: 64"]B[/TD]
[TD="width: 64"]C[/TD]
[TD="width: 64"]D[/TD]
[TD="width: 64"]E[/TD]
[TD="width: 64"]F[/TD]
[TD="width: 64"]G[/TD]
[TD="width: 64"]H
[/TD]
[/TR]
[TR]
[TD="align: right"]1
[/TD]
[TD]Model[/TD]
[TD]Worktop[/TD]
[TD]Time[/TD]
[TD]Door[/TD]
[TD]Time[/TD]
[TD]Drawer[/TD]
[TD]Time[/TD]
[TD]Total subs
[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]a[/TD]
[TD="align: right"]0
[/TD]
[TD="align: right"]0 m
[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5 m[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]3 m[/TD]
[TD="align: right"]3
[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]b[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5 m[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10 m[/TD]
[TD="align: right"]0
[/TD]
[TD="align: right"]0 m[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]c[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0 m[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5 m[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0 m[/TD]
[TD="align: right"]1
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top