View Single Post
  #3   Report Post  
duane
 
Posts: n/a
Default


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