Hi!

Here's what I think you're asking for...

In sheet1 B5 enter this formula and copy down to B120:

=SUMPRODUCT(--(Sheet2!A$5:A$17244=A5),--(Sheet2!I$5:I$17244=1),Sheet2!F$5:F$17244)

For the other months: Feb, Mar, Apr etc, replace the 1 in the formula with
the corresponding month number or enter the month number in a cell and
reference that cell:

=SUMPRODUCT(--(Sheet2!A$5:A$17244=A5),--(Sheet2!I$5:I$17244=A$1),Sheet2!F$5:F$17244)

Biff

"GregR" wrote in message
oups.com...
I need help with a formulas to populate a table that has Project
numbers on sheet1, range(a5:a120) that I want to match to sheet2,
range(a5:a17244) and return the sum of values, sheet2, range(f5:f17242)
that match Jan, entered as 1, found in sheet2, range(i5:i17244). Then
repeat for Feb, Mar, etc. Any help would be greatly appreciated. TIA

Greg