Hello, I am using the below formula to take mulitple addresses and count them as one. The formula works great, but I need to add one more criteria to it. The report I am pulling within my company is data for all locations. So I need to be able to break it apart by account number. So I need to add to the IF statement account number first and then run the formula. Any help would be greatly appreciated. Thanks
=SUM(IF(FREQUENCY(MATCH(N2:N10,N2:N10,0),MATCH(N2:N10,N2:N10,0))>0,1))
=SUM(IF(FREQUENCY(MATCH(N2:N10,N2:N10,0),MATCH(N2:N10,N2:N10,0))>0,1))