Match 2 Criteria

G

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
 
B

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
 
G

GregR

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

Greg
 
B

Biff

You're welcome! Thanks for the feedback.

Biff

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

Greg
Click to expand...
 
Top