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
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!