Hi All,
I'm having trouble trying to figure something out.
First, I have a COUNTIFS statement giving me the total number of unique rows which have the following criteria:
=COUNTIFS('October by Channel'!$K:$K,Summary!AJ3,'October by Channel'!$J:$J,Summary!AJ2,'October by Channel'!$Q:$Q,Summary!$B$5)
Problem is, there are duplicate Order numbers within this data, so I have a separate formula which is showing me unique order numbers, as follows:
=SUM(IF(FREQUENCY('October by Channel'!A:A,'October by Channel'!A:A)>0,1))
However, I need to somehow get the unique order numbers combined into the countifs formula.
Can anyone help?
Many thanks
Bookmarks