Using SumIF formulas with multiple lookup values

[Chris Freeman]

I need to use a sumif-like formula that totals like a sumif, but have
multiple lookups like a sumproduct. The formula would lookup a persons name
AND a date entered another field that is used as the filter, within a list of
names, dates, and column values. I tried this but it didn't work:
SUMIF('Raw Data'!$B$2:$B$200,--('Chart Data'!$F$4,--('Chart
Data'!$B$12)),'Raw Data'!E$2:E$200)

Let me know if you need clarification

Thanks in advance

 

[Aladin Akyurek]

I need to use a sumif-like formula that totals like a sumif, but have
multiple lookups like a sumproduct. The formula would lookup a persons name
AND a date entered another field that is used as the filter, within a list of
names, dates, and column values. I tried this but it didn't work:
SUMIF('Raw Data'!$B$2:$B$200,--('Chart Data'!$F$4,--('Chart
Data'!$B$12)),'Raw Data'!E$2:E$200)

Let me know if you need clarification

Thanks in advance

A name and a date as conditions would require a formula with a different
function than SumIf. One option is:

=SUMPRODUCT(--(NameRange=Name),--(DateRange=Date),SumRange)

 

[Aladin Akyurek]

=SUMPRODUCT(--(Resource="COLLINS"),--(Date1=B10),phase1)

Resource, Date1, and phase1 should all be 1D (that is, just vectors) and
of the same size.