How to count with condition

Hi.

please help me how can i summaries with counting with condition with attach file:

Try this to find count of A with Submit = "Y"

Formula:

=SUMPRODUCT(--(B3:B16=B23),--(D3:D16="Y"))

For A with not Submit

Formula:

=SUMPRODUCT(--(B3:B16=B23),--(D3:D16<>"Y"))

Change the range D3:D16 to E3:E16 for finding approve/not approve.

You can try countifs formula if you are using 2007 and above version.