Create a formula that contains a complex embedded IF statement

T

Tom

I received a spreadsheet from someone a couple of years ago that contains the
formula below and I need to know the keying sequence that brackets the
formula enabling the COUNT function to factor the IF statement with 2
variables.

{=COUNT(IF((Consolidated!$AU$2:Consolidated!$AU$47581<=$C$1)*(Consolidated!$AV$2:Consolidated!$AV$47581="P"),Consolidated!$Q$2:Consolidated!$Q$47581))}
 
Top