Hi
I have a table of data that I am using countifs to return the number of accounts that meet my criteria, the problem I have is within the data I have multiple rows of the same account so they are being double counted. Is there away around this?
In my data I have Account number, customer name, date, product, sales person, revenue and I'm trying to make a summary so i'm using countifs to count the accounts where a date falls with a certain month, the sales rep matches the summary name and the revenue is greater than £299 but how do I get it to count only unique account numbers?
I have a table of data that I am using countifs to return the number of accounts that meet my criteria, the problem I have is within the data I have multiple rows of the same account so they are being double counted. Is there away around this?
In my data I have Account number, customer name, date, product, sales person, revenue and I'm trying to make a summary so i'm using countifs to count the accounts where a date falls with a certain month, the sales rep matches the summary name and the revenue is greater than £299 but how do I get it to count only unique account numbers?