|I'm trying to add total charges from invoices calculated in several worksheets in Excel 2003. |
What I've done thus far:
The following formula will look for the total sum in F32 in all worksheets between the "Start2009" and "End2009" worksheets and return the total value of F32 for all sheets.
Now I need to find total charges for a period of time. The following formula will look in column C cells to check the range of dates in the invoice on the same worksheet. If the requested date range is found (example: 01/01/09 to 03/31/09 a.k.a. 1st Quarter) the total sum in cell F32 from each invoice will be returned.
I can only do the above formula on the same worksheet in which the dates in C17:C31 and invoice total in F32 are entered. But I want to create a "Totals" worksheet at the end of the workbook that will give me updated quarterly totals pulling the data (based on dates query) from all worksheets, and as I create new worksheets for new billing invoices and insert between the Start2009 and End2009 worksheets the formula will updated the "Totals" worksheet. Is this clear? I basically need to combine the two formulae above with the ability to search multiple worksheets for dates in a range to return the value of F32.
I've tried SUMPRODUCT, but that didn't work. It's the date search that has me stymied.
Thanks for the help.