Hi All,

=COUNTIFS(Sheet1!D:D,Sheet2!$C$4,Sheet1!AB:AB,B7,Sheet1!AA:AA,{"Validation Pending","In-Progress"})

in the above formula, it works if dont use {}. i did Countifs+countifs to get the value.

someone told me that {} also works....
please help