Im trying to create a formula that will sum the values of one colum
based on the values of two other colums

Colum A is Date
Colum C is Name
Colum E is a Time value

Im trying sum the times values based on criteria from colums a and c

I want to sum the time Of a person on a certain date for an entire
colums length

I have used the sumif forumla but that only allows 1 type of criteria
to be matched and i need to match it based on two types of criteria.

Here is a sample sumif command that works but only gives me the sum of
all values of a day

=SUMIF('Incoming Calls'!A:A,B5,'Incoming Calls'!E:E)
or vice versa
=SUMIF('Incoming Calls'!C:C,A4,'Incoming Calls'!E:E)

I need a sum of colum E based on these two criteria.

Any suggestions?


--
mav3n
------------------------------------------------------------------------
mav3n's Profile: http://www.excelforum.com/member.php...o&userid=26062
View this thread: http://www.excelforum.com/showthread...hreadid=394015