Hi,
Please can you help me understand why this formula isn't working:
=IF(F675<>"Ticket","",SUMPRODUCT(($O$13:O675=O675)*($F$13:$F675="Ticket")*AND($E$13:$E675<>"Completed",$E$13:$E675<>"Cancelled")))
If Column E contains anything other than completed and cancelled I want the formula to count but it isn't. If I take out the AND at the end and just count <> completed it works perfectly...
=IF(F675<>"Ticket","",SUMPRODUCT(($O$13:O675=O675)*($F$13:$F675="Ticket")*($E$13:$E675<>"Completed")))
Thanks
Andy
Bookmarks