Hi
I have this formula that I wrote in Excel 2010 using countifs function. I need to make it work in 2003. I belive using the sumproduct function might work, but I am not sure how to change it so it works. Here is what works in 2010
=COUNTIF('Capa ontime '!BO:BO,"CAPA")/COUNTIFS('Capa ontime '!BO:BO,"CAPA",'Capa ontime '!CN:CN,"<>Closed - Done",'Capa ontime '!CN:CN,"<>Complete")*0.1
Thanks
Bookmarks