Sum product

G

Guest

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?
 
B

Bob Phillips

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

Peo Sjoblom

It's no difference from summing anything else

=SUM(Range)

use [hh]:mm

as format if the total hours is greater than 24
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls help for Simple Calculation 1
Formatting time 2
Subtraction formula 7
Pivot Table Summarizing Quirk - Please Help 1
Multiple Count IF 's 1
Counting if Date1 is after and Date2 is before another date 5
Date wise Sum Formula required 5
Average HH:MM:SS 1

Top