Sumproduct help please

[Axyr]

A B C
10/31/2003 10:50:06 AM Chris Grider 59.95
10/31/2003 12:05:26 PM John Dill 101.25
11/01/2003 12:02:20 PM Chris Grider 72.25


Ok I desperatley need help I just dont seem to be able to think this
one thru this is what I have so far

=SUMPRODUCT((A1:A3="1/1/2003")*(B1:B3="Chris Grider")*C1:C3)


What I need it to do is when its 10/31/03 and the tech is Chris Grider
then sum column c

 

[Bob Phillips]

Try this form

=SUMPRODUCT((A1:A3=DATE(2003,10,31))*(B1:B3="Chris Grider"),C1:C3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
the problem is your data comparison (exspecially as you have
dates/tgimes in column A). One way:
=SUMPRODUCT((TRUNC(A1:A3)=DATE(2003,10,31))*(B1:B3="Chris
Ginder")*(C1:C3))
for date calculations have a look at
http://www.cpearson.com/excel/datetime.htm

HTH
Frank

 

[Frank Kabel]

Hi Bob
I don't think this will work as OP's column A consist of date and
times. In my testing the formula below would return 0
Regards
Frank

 

[Bob Phillips]

Hi Frank,

Yes, you are right. I was just seeing the date format of the OP, a form I
can never get to work (although I believe others do).

Bob

 

[Axyr]

Wow thanks so much it works

=SUMPRODUCT((TRUNC(A1:A3)=DATE(2003,10,31))*(B1:B3="Chris
Grider")*(C1:C3))

This helped me so much