Good Afternoon All,
Looking for some help with a project.
I am using the following sum,
=IF((AND(U3="High", V3>="Open",Y3>G3)), "Pass", "Fail")
the issue I have is that there is a further argument that I need, essentially in column K are the references for my table and the above sum could return a "Pass" for several "Open" tasks on one reference. I need it to look at all the above arguments but only count each reference once.
any help you can provide me will be really appreciated.
Kind regards
r
Bookmarks