hi all
i have this formula: =SUM(--(FREQUENCY('1'!$B$7:$B$500,'1'!$B$7:$B$500)>0))
which gives me the total amount of invoice numbers in the desired range.
how can i tell it to only total the unique invoice numbers in the desired range that have a certain value in column L of that row i.e...