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)) }
|