If formula on range with multiple conditions

Copper Contributor

I am looking to put in and 'if' formula (or similar).

This formula is based on all rows of a table, over two columns.

The formula should give a result of Yes or No (or similar).

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.

 

 

1 Reply

@MrStern 

Shouldn't the result in your sample workbook be FALSE/No/0 since there is a row with TRUE in the delivered column but no name in the Signed By column?

If so, you can use

 

=COUNTIFS(Table1[Delivered],TRUE,Table1[Signed By],"")=0