COUNTIF and OR or IF Formula

Jack Parry

I'm looking to use COUNTIF to calculate if something is the right date and then if it has meets one of the following criteria (using references).

My current formula looks like this:

=COUNTIFS({Despatch Report Date}, =Date8, {Despatch Report Lot Status}, "Q", {Despatch Report WO Status}, <99

I basically want to count if its the right date and then count if meets one of the criteria, e.g. its in Q or its less than <99

Adding OR and @cell, doesn't work because my references are different columns.

=COUNTIFS({Despatch Report Date}, =Date8, OR({Despatch Report Lot Status}, "Q", @cell), {Despatch Report WO Status}, <99, @cell)

Would it be better to use an IF statement at the start of the formula?

Pat Canning

Does this work?

Pat Canning

Does this work?