I am trying to create a formula that auto-calculates a summary page and cannot work out how to create the formula.
Essentially what I am trying to achieve is;
1. Identify date entries within a specified date range
2. Of those in the desired date range, I would like to use customer reference numbers to ensure that only unique entries are returned
I think I need to use a COUNTIF formula but don't seem to make it work.
I hope that makes sense, this is my first forum post!
COUNTIF QUERY.xlsx
Bookmarks