# ***Need help with formula

#### hercule_p2001

##### New Member
Hello!

I have a sheet on which in the range AL3:AS14 there is data retrieved from Access database. Row AL3 is the header row with e.g. following names:

Month - Cat1Expense - Cat2Expense - Cat3Expense - - - - Cat7Expense

The column Month has the entries for month in the yyyymm format from July to June:
200906
200907
200908
...
201006

In the same sheet from cell A1 I have the expense report made which currently I fill manually from the range mentioned above. The data is transposed with month as the header and category expenses in rows. BUT I can't use the transpose function because there are some fixed expenses that do not change and so are interspersed with the changing expenses like following:
Note: FE is for Fixed Expense. CE is for Category Expense

*** Jun-09 Jul-09 Aug-09 & so on
FE1 500 500 500
FE2 120 120 120
CE1 :get the data from Cat1Expense for the respective month:
CE2 : ---------same for Cat2Expense-----------------------:
Subtotal: SUM of the above(FE1+FE2+CE1+CE2)

CE3
FE3
FE4
Subtotal (CE3+FE3+FE4)

CE4
CE5
CE6
CE7
Subtotal(CE4 to CE7)

TOTAL - sum of all subtotals.

Can we use array formula is some way to make the task easier?

Thanks

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

#### westconn1

##### Board Regular
i guess you could transpose the cat expenses, then insert rows for the fixed

#### hercule_p2001

##### New Member
Thanks for responding but there is a problem with that. I have to do this at the end of each month. So if I did it for this month and inserted the rows for fixed expenses, how will it then work the next month? What I am trying to achieve is to automate the whole process since the data is already there. I am looking for some nested formulae into the cells that should get the data.

Replies
4
Views
298
Replies
2
Views
1K

1,191,276
Messages
5,985,710
Members
439,975
Latest member
eelyn

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