Need Help with Sum of Filtered Material

Hello, i currently have a spread sheet of truck load counts. with Columns as Date/Truck#/Truck Type/#of Loads/ Calculated Volume/ Activity/ Secondary Activity.
Most of it I enter manually but the Calculated volume calculates itself. What i'm after is on another sheet, picking any date, or number of days, and it automatically adding up all the sums the individual activities separately. For example

Date | Activity 1 | Activity 2 | Activity 3 | Activity 4 | Secondary Activity 1 | Secondary Activity 2 | Secondary Activity 3 | Secondary Activity 4 |
May 2 20012 | 450 | 320 | 0 | 110 | 0 | 0 | 120 | 500 |
Any help would be awesome.

If you could provide a sample workbook, I'll have a look.