View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Albert Albert is offline
external usenet poster
 
Posts: 203
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