Thansk Pete but I want to filter one column and subtotal that column and then use a criteria to sum different things in another column see below. Want to filter direction and then want totals for Cash, Credit cards etc that must change according to the filter. thank you
Year Plaza Direction Date Hour No Class MOP Vehicle Count Row
Cash
Credit Card
Document
e-tag PO
Violation

2012 CAROUSEL MAIN North 27-04-2012 12 1 Cash 2,579 1
2012 CAROUSEL MAIN South 27-04-2012 12 1 Cash 371 1
2012 CAROUSEL MAIN North 27-04-2012 12 1 Credit Card 716 1
2012 CAROUSEL MAIN South 27-04-2012 12 1 Credit Card 173 1
2012 CAROUSEL MAIN North 27-04-2012 12 1 Document 1 1
2012 CAROUSEL MAIN North 27-04-2012 12 1 e-tag PO 38 1
2012 CAROUSEL MAIN South 27-04-2012 12 1 e-tag PO 22 1
2012 CAROUSEL MAIN North 27-04-2012 12 1 Violation 3 1
2012 CAROUSEL MAIN North 27-04-2012 12 2 Cash 43 1
2012 CAROUSEL MAIN South 27-04-2012 12 2 Cash 16 1
2012 CAROUSEL MAIN North 27-04-2012 12 2 Credit Card 5 1
2012 CAROUSEL MAIN South 27-04-2012 12 2 Credit Card 17 1
2012 CAROUSEL MAIN North 27-04-2012 12 2 e-tag PO 1 1
2012 CAROUSEL MAIN South 27-04-2012 12 2 e-tag PO 1 1