I am trying to combine a If(is(numbersearch combination with a Frequency formula , i am not using sumproduct as want to return a complete total if criteria is blank.
Where i am trying to get to
When a certain validation is entered it returns the number of individual number combinations in a column ignoring duplicates (columns are number only not text)
Hope you can Help
Very striped down Example attached
Bookmarks