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.

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?

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.

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.