View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
 
Posts: 570
Default 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)) }