Summarise data with multiple filters

[mikerstevens]

I have a table (table1) that has date, category and £amount columns. I'm trying to create a summary table (table2) that summarises each category showing the £total (ie category, £total columns). I can do this using "sumif".

I'd now like to refine this to total only those items within a given date range so that I can use the same table2 for different periods for financial reporting.

I'm not sure how to capture the date range (eg one cell for the start date and another for the end date or some other way) and what function to use to pick up this date range?

My current formula for the £total including ALL dates is =sumif(Category_range_in_table1,Category_in_table2,£mount_range_in_table1)

Thanks

[Palmetto]

Use a Pivot Table.

[karan]

Do you have a sample workbook demonstrating some class sheets and a mockup of the output sheet you want?

Click GO ADVANCED and use the paperclip icon to post up your workbook.

Regards,
Karan

[Palmetto]

Still recommend the Pivot Table - it is very efficient.

Where:
A1 contains the category criteria
B1:C1 contain the start/end dates

"Amount" is the table column (header name) to sum

=SUMPRODUCT(--(Table1[Date]>=$B$1),--(Table1[Date]<=$C$1),--(Table1[category]=$A1),(Table1[Amount]))

[mikerstevens]

Karan - I've posted the spreadsheet - could you have alook at it please? Thanks