Or this one:

=SUMPRODUCT(('Outlook Tasks'!G2:G885="A")
*('Outlook Tasks'!I2:I885={"OVERDUE","Future"}))

Dave Peterson wrote:

Ahh. I missed the point of the question.

=SUMPRODUCT(--('Outlook Tasks'!G2:G885="A"),
--('Outlook Tasks'!I2:I885="OVERDUE")
+('Outlook Tasks'!I2:I885="Future"))

To include "Future"

duane wrote:

I suspect this will not give the desired result,,,the sum of the two
sumif will give you the number of times "A" shows up in column G + the
number of time "OVERDUE" shows up in column I. I think you were
looking for the number of times item "A" was overdue, if so

=sumproduct(('Outlook Tasks'!G2:G885="A")*('Outlook
Tasks'!I2:I885="OVERDUE")*1)

--
duane

------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=320491

--

Dave Peterson

--

Dave Peterson