davewatson86
New Member
- Joined
- Jul 8, 2019
- Messages
- 30
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
column A Column F
[TABLE="width: 157"]
<tbody>[TR]
[TD]50887011 fennell[/TD]
[/TR]
[TR]
[TD]50887011 fennell[/TD]
[/TR]
[TR]
[TD]50886969 mynett[/TD]
[/TR]
[TR]
[TD]50886314 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886055 fennell[/TD]
[/TR]
[TR]
[TD]50885990 mynett[/TD]
[/TR]
[TR]
[TD]50885956 mynett[/TD]
[/TR]
</tbody>[/TABLE]
my desired result is that if: mynett is my qualifier it should be 3
watson is my qualifier it should be 1
fennell is my qualifier it should be 2
Many thanks for your help it is greatly appreciated.
regards
Dave
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
column A Column F
[TABLE="width: 157"]
<tbody>[TR]
[TD]50887011 fennell[/TD]
[/TR]
[TR]
[TD]50887011 fennell[/TD]
[/TR]
[TR]
[TD]50886969 mynett[/TD]
[/TR]
[TR]
[TD]50886314 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886514 watson[/TD]
[/TR]
[TR]
[TD]50886055 fennell[/TD]
[/TR]
[TR]
[TD]50885990 mynett[/TD]
[/TR]
[TR]
[TD]50885956 mynett[/TD]
[/TR]
</tbody>[/TABLE]
my desired result is that if: mynett is my qualifier it should be 3
watson is my qualifier it should be 1
fennell is my qualifier it should be 2
Many thanks for your help it is greatly appreciated.
regards
Dave