Using COUNTIFS with multiple ranges & criteria...how to count unique / exclude duplicates?

Hello!

I am trying to get a count of reports we published, where I have taken data from another source which contains some items marked 'n/a' to be excluded from the count, and I want the count separated into specified time periods. Cells with no values are also excluded. I have figured out formulas to achieve this so far, but I need it to count unique values, as for the purposes of the original source data which is grouped differently, the reports come listed once per subject, even though the same report may cover multiple subjects.

For the 1Q14 count, I have given the formula:

Please Login or Register  to view this content.

...where the E range contains the names of reports and the D range contains the dates. G1 and G2 are the start and end dates of the 1Q14 period. Sometimes 2 or more uniquely-titled reports were issued on the same day so duplicate dates should be counted, but duplicate report titles only once.

I've put this sheet up as a Google Spreadsheet to illustrate: https://docs.google.com/spreadsheets...it?usp=sharing

Any help would be much appreciated.

Thank you for the welcome, and thanks also for taking a look at this.

In the Google Spreadsheet I had added comments to the cells containing formula-calculated counts for the 1Q13 and 3Q13 periods. They are giving 16 and 40 respectively, where I believe they should return 14 and 7 excluding duplicates. I believe 2Q13 is accurate with 11, and I haven't manually gone through the rest. Is that a good enough start?

Thanks to both of you, both of these solutions work brilliantly!

And you are right, XOR LX, the count for 3Q13 should be 8, not 7.

Extremely grateful.