If formula on range with multiple conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-2298179%22%20slang%3D%22en-US%22%3EIf%20formula%20on%20range%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2298179%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20put%20in%20and%20'if'%20formula%20(or%20similar).%3C%2FP%3E%3CP%3EThis%20formula%20is%20based%20on%20all%20rows%20of%20a%20table%2C%20over%20two%20columns.%3C%2FP%3E%3CP%3EThe%20formula%20should%20give%20a%20result%20of%20Yes%20or%20No%20(or%20similar).%3C%2FP%3E%3CP%3EThe%20check%20should%20be%20that%20if%20all%20'Trues'%20in%20the%20'delivered'%20column%2C%20have%20a%20name%20recorded%20next%20to%20it%20in%20the%20'Signed%20By'%20column%2C%20Then%20Yes%2C%20if%20Not%20No.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2298179%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2298200%22%20slang%3D%22en-US%22%3ERe%3A%20If%20formula%20on%20range%20with%20multiple%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2298200%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F486340%22%20target%3D%22_blank%22%3E%40MrStern%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShouldn't%20the%20result%20in%20your%20sample%20workbook%20be%20FALSE%2FNo%2F0%20since%20there%20is%20a%20row%20with%20TRUE%20in%20the%20delivered%20column%20but%20no%20name%20in%20the%20Signed%20By%20column%3F%3C%2FP%3E%0A%3CP%3EIf%20so%2C%20you%20can%20use%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIFS(Table1%5BDelivered%5D%2CTRUE%2CTable1%5BSigned%20By%5D%2C%22%22)%3D0%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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