#Invalid Data Type Formula Issue - Formulating % to plan

KABridges

Hello,

I am trying to count performance to plan. I need to know if the required for ER is checked and the estimated complete date is DDMMYYY or earlier what the % should be.

=COUNTIFS([Required for ER Start]3:[Required for ER Start]929, 1, AND([Baseline Estimated End]3:[Baseline Estimated End]929, AND(ISDATE(@cell), @cell <= [Date for PTP]@row))) / COUNTIFS([Required for ER Start]3:[Required for ER Start]929, 1, AND([Baseline Estimated End]3:[Baseline Estimated End]929, ISDATE(@cell)))

Paul Newcome

Lets start with cleaning up the syntax a little bit. What happens when you use this:

=COUNTIFS([Required for ER Start]3:[Required for ER Start]929, 1, [Baseline Estimated End]3:[Baseline Estimated End]929, AND(ISDATE(@cell), @cell <= [Date for PTP]@row)) / COUNTIFS([Required for ER Start]3:[Required for ER Start]929, 1, [Baseline Estimated End]3:[Baseline Estimated End]929, ISDATE(@cell))