Count Values not meeting Multiple Criteria

[Foreverlearning]

Hi,

What I am trying to do is count how many outstanding rows that have not been given a Award or Voucher number and excludes any rows that have Rec only

I have attached an example data showing criteria.

Any Help greatly appreciated

Thanks

[Dennis7849]

Take a look at your modified workbook attached. Take a close look at sheet1 column Y and Sheet2 cell D6.

[Foreverlearning]

Hi Denis,

Thank you for your response.

I guess I should mention that the records will come from a form input so that means I need to have VBA insert the formula onto end of every record.

Is this the best way to approach this?

Thanks

[Haseeb Avarakkan]

Try COUNTIFS in Sheet2!D6,

=COUNTIFS(Sheet1!A2:A65536,"<>",Sheet1!P2:P65536,"",Sheet1!W2:W65536,"",Sheet1!X2:X65536,"")