I've read through the forums but found nothing that solves my problem. My apologies if the answer is here somewhere and I've missed it.

I have a Google spreadsheet with multiple pages, each tracking a different account. I have a summary page on which I want to display the data in a meaningful way.

On each page I have something like the following:

Column A- date
Column B- amount
Column C- category

How do I create a cell on the summary page to show the sum total of amounts in all sheets that are in column b which transpired between January 1 and January 31 and represent a given category?

Right now I have this:

=ABS(sumif(SHEET1!C2:C, "Widgets", SHEET1!B2:B)+sumif(SHEET2!C2:C, "Widgets", SHEET2!B2:B)+sumif(SHEET3!C2:C, "Widgets", SHEET3!B2:B))

That gives me a sum of everything spent on Widgets in all accounts. What I can't seem to do is find a way to also tell the spreadsheet to limit the summary to a given date range.

Please help me solve this problem.