Try this:
=COUNTIFS(Predicted!JT4:JT140,">=3",Predicted!C4:C140,C6)/(COUNTA(Predicted!JT4:Predicted!JT140)-COUNTBLANK(Predicted!JT4:Predicted!JT140))
Try this:
=COUNTIFS(Predicted!JT4:JT140,">=3",Predicted!C4:C140,C6)/(COUNTA(Predicted!JT4:Predicted!JT140)-COUNTBLANK(Predicted!JT4:Predicted!JT140))
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks