I need to know how many second drafts required minor or major revisions. These are the two sets of countif functions I need:
=COUNTIF({Completed Reports Draft No.}, =2) — answer returns fine at 11.
=COUNTIF{Completed Client Comments}, "Major Comments, DCF Needed") — answer returns fine at 10.
However, when they are put together with a COUNTIFS, the answer returned is 0 when it should be 5.
For minor revisions, the countif formula is:
=COUNTIF({Completed Client Comments}, "Minor Comments, Additional Draft Needed") — answer returns correct value at 6.
However, when put together with the first and using COUNTIFS, it returns zero instead of 5. What is the problem here? I got the same set to work from another sheet without issue.
Thank you!
