I have a data set on its own separate sheet. On another sheet I have a report. This report is supposed to say,

how many deals were closed between a certain time period by this specific user, without duplicates of a certain column.

Currently I use this:

=COUNTIFS(Data!$B$6:$B$200,">="&Data!$B$1 [date1] ,Data!$B$6:$B$200,"<="&Data!$C$1 [date2] ,Data!$C$6:$C$200,"="&A6 [specific person] ,Data!$G$6:$G$200,"*setup")

it counts if the data is between a certain range, if it is by a specific person, and if it is a setup.

the problem I have is that one customer can have two setups, and this counts both of them. This makes the specific person seem like they are doing better then they really are.

is there a way with countifs to avoid duplicates in lets say, colum e? and otherwise how would I do this?

Sorry if this is confusing... I don't have a great grasp of the problem.