UNPARSEABLE Error

AliT

Hi.

I am trying to pull from my contracts management sheet, the number of "Executed" contracts that have a "Y". For background info, the "Y" denotes the last and active executed contract in a series. I don't want it to count all multiple executed contracts/amendments just the most recent one.

=COUNTIFS({Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4},"Y")

This is my formula and it worked perfectly ending at "Executed" until we made the "Y" Change and I had to update the formula. Now of course its not working.

Paul Newcome

I don't see anything wrong with the formula in your post that would be throwing that error.

Are you able to provide a screenshot of the formula actually in the sheet similar to the snippet below?

AliT

Thank you Paul. Right after I sent the question and went back to my formula it was working. Perhaps I just needed to save or refresh. Again, Thank you for the reply.