COUNTIF formula question

I am trying to create a COUNTIF formula to count a column's status specifically for "Live Engagements" but I think I am messing it up.

=COUNTIF({Demand Management For IT Projects Range 2]:[Column6]2[Project Stage],"Live Engagements")

Any Suggestions? It says Unparseable.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    When creating a cross sheet reference, start typing the formula:


    In the formula helper box you should see a little blue link that says "Reference another sheet". Click on that, select the sheet you want to reference, then select the range you want to reference (click on a column header to reference an entire column). Click on the "Insert Reference" button near the bottom right corner and it should take you back to your working sheet where you now see...

    =COUNTIFS({Sheet Name Range #}

    From there you would continue with the syntax of whatever function you are working in. In this case you would type a comma then enter your criteria.