confused in Frankfurt
Board Regular
- Joined
- Oct 11, 2010
- Messages
- 53
Deal ID | Sales Rep | Quarter | Value | Product | |
<tbody> </tbody> | Fred Blogs | 4 | 1.000 | bread | |
<tbody> </tbody> | Fred Blogs | 4 | 20.000 | butter | |
<tbody> </tbody> | Fred Blogs | 3 | 45.000 | bread | |
<tbody> </tbody> | John Smith | 4 | 30.000 | bread | |
<tbody> </tbody> | John Smith | 4 | 45.000 | butter | |
<tbody> </tbody> | Fred Blogs | 4 | 50.000 | bread |
<tbody>
</tbody>
Result should be : Fred Blogs 1 and John Smith 1 (30+45)
If I am ignoring the duplicates and counting just every thing I am using the formula
=countifs(Range1;...)
but this is either giving me too many deals to use for calculating average deal size or too few because the split deal value is below the benchmark set.
Regards
Sarah