Need formula to calcuate from multiple worksheets that have their own formuals

[jamilyn]

I have a quarterly sales tax spreasheet with use for our company that I created. Each month I need to input all the paid invoices and include the city, taxable, non taxable, etc. I created a drop down for the the city, which then auto populates the appropriate sales tax and which county. I now need that info to auto populate into the county portion of the quarterly worksheet which is named "QE 02 13".

See attached.

Can anyone help? Also, don't use this attachment, see the one further in the thread. This one has a password.

[AZ-XL]

YOur file is in code.

[jamilyn]

It didn't upload correctly?

[jamilyn]

oops, I left the password on it. Here is the spreadsheet again. )Hopefully I grabbed the right one.

I tried this code but it's not calculating =SUMIF('April 13'!I:I,"Alameda",'April 13'!E:E) and it works but I need to add in the other two worksheets. somehome tie these 3 together???
=SUMIF('April 13'!I:I,”Alameda”,'April 13'!E:E)
=SUMIF('May 13'!I:I,"Alameda",'May 13'!E:E)
=SUMIF('June 13'!I:I,"Alameda",'June 13'!E:E)

[jamilyn]

I figured it out!! It was....
=SUMIF('April 13'!I:I,"Alameda",'April 13'!E:E)+SUMIF('May 13'!I:I,"Alameda",'May 13'!E:E)+SUMIF('June 13'!I:I,"Alameda",'June 13'!E:E)