Sumproduct help please

  • Thread starter Thread starter Axyr
  • Start date Start date
A

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