Create a formula that contains a complex embedded IF statement
 

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$47 581<=$C$1)*(Consolidated!$AV$2:Consolidated!$AV$47 581="P"),Consolidated!$Q$2:Consolidated!$Q$47581)) }

Create a formula that contains a complex embedded IF statement
 

Just enter it with ctrl + shift & enter as opposed to enter


--
Regards,

Peo Sjoblom


"Tom" wrote in message
...
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$47 581<=$C$1)*(Consolidated!$AV$2:Consolidated!$AV$47 581="P"),Consolidated!$Q$2:Consolidated!$Q$47581)) }