Create a formula that contains a complex embedded IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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))}
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'IF' Statement for a Concaterate Formula 2
'IF' Statement for a Concaterate Formula 1
How do I get a worksheet reference to increment when copied 9
Adding same cells across multiple worksheets 2
Excel If statement copy only if ISNumber result is yes 1
Formulae exceeding 1024 characters 9
adding figures that match 2 true and 1 false if statement conditio 5
Summary using sumif 9

Back
Top