View Single Post
  #1  
Old May 21st, 2009, 07:39 AM posted to microsoft.public.excel.misc
Albert
external usenet poster
 
Posts: 92
Default 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