Why would these Countifs not work together?

Susan Zimmerman

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!

Paul Newcome

Can you provide an example of how you are putting them together?