I'm trying to do a sum product with the attached data:

A B C
List of ID numbers Date Time (hh:mm:ss)
Mobile 11 18/03/2007 00:00:30
Mobile 11 18/03/2007 00:01:25
Mobile 11 19/03/2007 00:01:00
Mobile 25 18/03/2007 00:02:01

So I want to sum the time in hh:mm:ss for ID 11 for 18/03/2007.

Looks like its =Sumproduct(--(a2:a5="Mobile 11"),--(b2:b5="18/03/2007"),c2:c5)
but I keep getting errors e.g value or name??

Any suggestions please?

=Sumproduct(--(a2:a5="Mobile 11"),--(b2:b5=--"2007-03-18"),c2:c5)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Virginia" wrote in message
...
I'm trying to do a sum product with the attached data:

A B C
List of ID numbers Date Time (hh:mm:ss)
Mobile 11 18/03/2007 00:00:30
Mobile 11 18/03/2007 00:01:25
Mobile 11 19/03/2007 00:01:00
Mobile 25 18/03/2007 00:02:01

So I want to sum the time in hh:mm:ss for ID 11 for 18/03/2007.

Looks like its =Sumproduct(--(a2:a5="Mobile
11"),--(b2:b5="18/03/2007"),c2:c5)
but I keep getting errors e.g value or name??

Any suggestions please?

How do I sum time?


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

It's no difference from summing anything else

=SUM(Range)

use [hh]:mm

as format if the total hours is greater than 24


--
Regards,

Peo Sjoblom

<Abby Vela wrote in message ...
How do I sum time?


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com