COUNTIF and OR or IF Formula
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?
Best Answer

Does this work?
Answers

Does this work?
Help Article Resources
Categories
Check out the Formula Handbook template!