I need formula assistance with my summary worksheet. I want to take data
from my daily tracking log sheet of an item of two sizes (2's,3's(column E))
with six destination (Virginia, Kentucky, etc.(Column G - not shown in
eqation)) and give the cubic meters of the load (Column I) provided that both
criteria are met.

As one can see from the below eqation that it is easy to use a SUMIF
function to do this when the range is given. the problem arises when the
destination are intermitten and not continuous. I do not want to have a
string of SUMIF eqations.

=SUMIF('Daily Log'!E52:E55,2,'Daily Log'!I52:I55)+SUMIF('Daily
Log'!E57:E60,2,'Daily Log'!I57:I60)

I have tried to nest with an AND statement as well as IF. No luck with MATCH
and FIND. I either get a false or it only reads the first destination and
suns all of I regardless of destination.

I need assistance with an eqation the uses a name and a numeral in the same
row for the criteria of a numeral that needs to be summed by meeting both
criteria and populates that into one cell on a seperate sheet.

Any assistance would be greatly appreciated.

LT Hettinger