Hi,

Sum your year column by criteria

=SUMPRODUCT((A2:A200="Dry Lease")*(G2:G200))

Mike

"Eric" wrote:

Below is a sample from a large table. I want to be able to sum the entire
sheet based upon year (i.e. 2010, 2011) and description (Dry Lease, ACMI).

I believe Sumproduct will do this, but I can't get it. Any thoughts are
greatly appreciated.

Q1 2010 Q2 2010 Q3 2010 Q4 2010 2010
Dry Lease 0.3 0.7 0.7 0.7 2.4
ACMI 0.9 1.8 1.8 1.8 6.4
Dry Lease 0.9 1.8 1.8 1.8 6.4
ACMI - - 0.3 0.7 1.0
ACMI - - - 0.3 0.3
Dry Lease - - - 0.3 0.3
Dry Lease - - - 0.9 0.9
Dry Lease - - - - -