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 Column B Column C date amount 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. 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?