If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compare budget to actual
Hi Guys,
I have drawn a blank. Please help? I have a spreadsheet which affectively are all items from my bank statement. In another spreadsheet I have all the catagories from my bank statement which is then filtered (sumif) between 2 dates. I would like to then to compare my budget against the actual but I have my budget setup in a cross tab table (categories in the rows and months in the columns) What formula could I use to pull through the corresponding budget to the date range in the bank summary sheet? Thanks Albert |
Thread Tools | |
Display Modes | |
|
|