Using SumIF formulas with multiple lookup values
 

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
--
Chris Freeman
IT Project Coordinator

Chris Freeman wrote:
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)

Alan
I tried this: =SUMPRODUCT(--(Resource="COLLINS"),--(Date1=B10),SUM(phase1))
and got the #value! error. Any ideas why?

Chris

"Aladin Akyurek" wrote:

Chris Freeman wrote:
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)

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

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

Chris Freeman wrote:
Alan
I tried this: =SUMPRODUCT(--(Resource="COLLINS"),--(Date1=B10),SUM(phase1))
and got the #value! error. Any ideas why?

Chris

"Aladin Akyurek" wrote:


Chris Freeman wrote:

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)