need help with formulas dont know how this is going to work

DevintheDude

Board Regular
Joined
Jun 8, 2007
Messages
153
x
Billing Billing Billing Billing Unit Pre Post
#1 #2 #3 #4

4 3 2 1 5 =bill* =sum(Bill
Unit 1-3) * Unit

Ok I have the cells set up above and this is based on the x above the billing #. So Bill 4 has the x so then pre is going to equal 1 times 5. Then post is going to sum of bill 1, 2 and 3 times the unit.

If you change the x to bill three i want the formula to account for the change and now pre will equal 2*3 and post will equal sum only one and two times the unit.

I used h lookup to the billing based on the x which is =HLOOKUP("x",$A$1:$D$20,4) but i dont know how that i can change the sum so that it will shift with the x and only sum what is before

The example is not aligned
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,122,915
Messages
5,598,850
Members
414,263
Latest member
sherrcha

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
Top