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

#### DevintheDude

##### Board Regular
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

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Replies
3
Views
516
Replies
2
Views
134
Replies
1
Views
114
Replies
8
Views
391
Replies
0
Views
337

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,559
Messages
5,832,500
Members
430,136
Latest member
Asir Jefferson

### 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.

### Which adblocker are you using?

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

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