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)
>>