Sumif or If or Nesting

[sachinattri]

hi there,

I have a set of data with Names in Column 1, Dates in Column 2 an
Dollars in Column 3. In Column 1, same person has purchased differen
things on different as well as same dates. If I want to specify tha
SUM if Name=Joe and Date=Oct 17 then SUM all corresponding values, ho
do I do that?

I have tried SUMIF, IF and SUMPRODUCT, I dont know where I seem t
lack.

Please help its easy but I just cant figure it out.

Thank you

Sac

 

[RagDyer]

With name to find in A1,
And date to find in B1,
And data list in A2:C100,
Try this:

=SUMPRODUCT((A2:A100=A1)*(B2:B100=B1)*C2:C100)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


hi there,

I have a set of data with Names in Column 1, Dates in Column 2 and
Dollars in Column 3. In Column 1, same person has purchased different
things on different as well as same dates. If I want to specify that
SUM if Name=Joe and Date=Oct 17 then SUM all corresponding values, how
do I do that?

I have tried SUMIF, IF and SUMPRODUCT, I dont know where I seem to
lack.

Please help its easy but I just cant figure it out.

Thank you

Sach

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100="Bob"),--(B1:B100=--("2004/12/23")),C1:C100)

 

[scott]

Check out array formulas

http://www.cpearson.com/excel/array.htm

 

[Domenic]

=SUMPRODUCT(--(A2:A100="Joe"),--(B2:B100=DATE(2004,10,17)),C2:C100)

Hope this helps