SumProduct Help

E

Eric

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

Luke M

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

Mike H

Hi,

Sum your year column by criteria

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can't center a category label on a line chart 1
Help with Date in SUMPRODUCT 5
Average If, with a Moving Target 0
Survey Results help 0
Use VLOOKUP in a sumproduct calculation 6
conditional summing progressively thru a matrix 2
Populating Form with Multiple Records From Query 0
Can anyone help me answer these questions or nay of them as im struggling with understanding the VBA 4

Top