I am looking to put in an if formula (or similar) in B1
The formula should give a result of Yes or No (Or True or False) or 1 or 0, the result does not really matter, it is just that it performs the check
The check should be that if all 'Trues' in the 'delivered' column, have a name recorded next to it in the Signed By column; then Yes, if not No)
So in the above table, it should show Y as there is no name recorded in B5
One way (of many!!):
=COUNTIF(Table1[Delivered],"True")=COUNTIFS(Table1[Delivered],"True",Table1[Signed By],"<>")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Try
=IF(COUNTIF(Table1[Delivered],"TRUE")=COUNTIF(Table1[Signed By],"<>"),"X","Y")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks