Hello,
I am looking to gather metrics from a sheet of QC submissions. I have a very limited understanding of formulas but have managed to put together something that works through looking at examples on here and the tutorials. I have had success with the following formula counting the number of submissions of a certain type (analysis type, in this case finished product) within another sheet and within a certain date range:
=COUNTIFS({QC Log Date Submitted}, IFERROR((@cell), 0) >= DATE(2021, 10, 1), {QC Log Date Submitted}, IFERROR((@cell), 0) <= DATE(2021, 12, 31), {QC Log Analysis Type}, "Finished Product")
When I adapt this formula to count the number 'Accepted' for QC disposition with everything else remaining the same I get the 'Incorrect argument set' error and I am at a bit of a loss as to why this isn't working. Formula below.
=COUNTIFS({QC Log Date Submitted}, IFERROR((@cell), 0) >= DATE(2021, 10, 1), {QC Log Date Submitted}, IFERROR((@cell), 0) <= DATE(2021, 12, 31), {QC Log QC Disposition}, "Accepted")
I thought perhaps it was because there are blank cells in the QC disposition column, but this formula is working which is counting Confirmed OOS in a column that also contains blank cells.
=COUNTIFS({QC Log Date Submitted}, IFERROR((@cell), 0) >= DATE(2021, 10, 1), {QC Log Date Submitted}, IFERROR((@cell), 0) <= DATE(2021, 12, 31), {QC Log Solubility}, "OOS - Confirmed")
All of the columns I am switching between in these formulas are single select dropdowns and restricted to those values only. If anyone can tell me where I am going wrong with this I would be very grateful.
Thanks
