Match 2 Criteria

[GregR]

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

 

[Biff]

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]

Biff, not only did you figure out the answer you figured out my question,
which may have been much harder. Thank you

Greg

 

[Biff]

You're welcome! Thanks for the feedback.

Biff

Biff, not only did you figure out the answer you figured out my question,
which may have been much harder. Thank you

Greg