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 - - - - -

assumes headers are row 1/column a respectively
=SUMPRODUCT((RIGHT(B1:F1,4)="2010")*(B2:F9)*(A2:A9 ="Dry Lease"))

And of crouse, you can replace "2010" and "Dry Lease" with cell references
to help make the formula more dynamic.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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 - - - - -

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 - - - - -

That did it. Thanks for your help.

"Mike H" wrote:

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 - - - - -