LinkBack URL
About LinkBacks
rgirardi 
Hi
=COUNTIF('Capa ontime '!BO:BO,"CAPA")/SUMPRODUCT(('Capa ontime '!BO1:BO100="CAPA")*('Capa ontime '!CN1:CN100<>"Closed - Done")*('Capa ontime '!CN1:CN100"<>Complete"))*0.1
Change the range 1:100 as appropriate
Hi
=COUNTIF('Capa ontime '!BO:BO,"CAPA")/SUMPRODUCT(('Capa ontime '!BO1:BO100="CAPA")*('Capa ontime '!CN1:CN100<>"Closed - Done")*('Capa ontime '!CN1:CN100"<>Complete"))*0.1
Change the range 1:100 as appropriate
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks